Category "powerbi-datasource"

Power BI Calculate distinct impacting when I use filter

I made a measure that is as follows: wo = CALCULATE( DISTINCTCOUNT('Table1'[won]), ALLEXCEPT(Table1, 'Table1'[flag]), ALLEXCEPT(Calendar,Calendar[End of Week]),

Issue with Power BI dataset refresh

I am using Azure Logic App workflows to refresh a Power BI dataset every 5 minutes. The workflow was working for several weeks without any issues . But since la

How do I configure the Service Principal credentials expiration on refresh to connect Power BI Sql Azure Data Source?

I am using Powershell to update credentials on a Power BI datasource based on Sql Azure. The credentials are that of a Service Principal's, I obtain a Sql acces

How to match the most approximate values of one column with the string column in another table in Power Query of Power BI?

Table 1: Table 2: Result: I have tried using Fuzzy matching but it's not giving me the results. Please help!

How to assign 1 st, 2 nd,3 rd etc based on number in date filed using power bi DAX formula?

How to assign automatically st/nd/rd/th to number behind in date field using power bi DAX formula. I'm creating labels for date something like this 1st MAY 202

PowerBI Hide 0 Values in the Page | PowerBI

Could someone advice how could be hide 0 values from all chars on the PowerBI page? For example when I clicking on chart A and want to filter just specific Axi

what kind of measure or column will use here

[Please refer to the below image. I want to create a stacked column chart but I don't have a column that includes 0-30, 30-60, 60-90, etc. How did I put this ra