How do you usually troubleshoot slow Power BI reports?
I work as a Power BI Analyst at Edoxi, and through my work with Power BI reports and data visualisation, I’ve found that report performance is not always related to dataset size. Even a relatively small model can become slow because of complex DAX measures, inefficient relationships, too many visuals, or expensive Power Query transformations. When troubleshooting performance, I usually start by checking these areas: Data model — Check whether the model is structured appropriately, such as using a star schema where suitable. DAX measures — Review calculations and iterators that may be unnecessarily complex. Relationships — Check cardinality, filter direction, and any ambiguous relationships. Visuals — Look at the number of visuals and interactions on the report page. Performance Analyzer — Identify which visual or query is taking the most time. Power Query — Review expensive transformations and check whether query folding is maintained where applicable. I’ve found that identifying the actual bottleneck first is more effective than changing multiple parts of a report at the same time. For other Power BI professionals and analysts, what performance issue do you encounter most often: DAX, data modelling, Power Query, or report design?
Workaround for OLS related Limitations
Hello Everyone, When we are dealing with OLS in our semantic model. We came up limitations, i would like to know if any workarounds. Before OLS implementation our Model Structure: Role A can see Column A. Role B can see both Column A and Column B. We use Column A and Column B in a same metrics & toggle between both based on the Logged in Roles. We used a Metrics to toggle between Column A and Column B. (Reason is both column meant for alike data display, eg, Profit and Profit_withMargin) We have 700 metrics. Now Challenge during OLS implementation: If we apply OLS in our model, When Role A logsin our metrics break because we Column B in the metric is been filtered by OLS feature. To overcome this we have two solution. One to create metrics seperately for each role. This will be heavy maintanence activity if any new role got added in future. Second to depivot the table in ETL. (Ex: Keep both Profit and Profit_withMargin in same column) and apply RLS. This will increase datasize alot. Chances of getting performance and load issue are high) Any one face similar issue and have anothe quick fix workaround? Please let me know. Thanks in Advance.Line chart
Hello All, I have a line chart which I want to create as below, in PBI: I can create almost everything but not able to create the deciosn pointers, which are hightlited as the small thick mark on each lines, not sure how can I get that. Below is the table which I want to use. country Forecast Accuracy - 3 month ahead Forecast Accuracy - 2 month ahead Forecast Accuracy - 1 month ahead Decision Point Spain 84 % 83 % 99 % 56 Brazil 96 % 95 % 97 % 50 Italy 79 % 71 % 80 % 56 India 81 % 84 % 82 % 15 Mexico 96 % 98 % 96 % 40 China 95 % 97 % 96 % 5 Germany 93 % 93 % 92 % 56 United States 99 % 98 % 100 % 35 United Kingdom 71 % 78 % 89 % 56
Slicer gets reset when using bookmark
Hi Folks, So I have a button slicer which is made up of bookmarks- Today,MTD,QTD,YTD.... Also, I have a between date range slicer and few other dropdown slicers. The button filters the between date slicer. Now the issue is when I select any value from the dropdown slicer and click on any of the bookmark button slicer, the dropdown gets reseted. I want to have the dropdown selected as well as view by Today,MTD,QTD,YTD button. Note, See how the facility Name gets reset when I select WTD. I have captured the bookmark by having a DAX in filter pane- filter in this page Is WTD = IF('Dim_Date'[Date] >= TODAY() - WEEKDAY(TODAY(), 1) + 1 && 'Dim_Date'[Date] <= TODAY(), "Yes", "No") Is MTD = IF(YEAR('Dim_Date'[Date]) = YEAR(TODAY()) && MONTH('Dim_Date'[Date]) = MONTH(TODAY()) && 'Dim_Date'[Date] <= TODAY(), "Yes", "No")
For Beginners to start
Hi everyone, I am a computer science student and new to Power BI. I have started learning Power BI through Microsoft Learn modules. Could you please suggest the correct beginner learning order and key topics to focus on in Power BI Desktop (data modeling, visuals, basics of DAX)? Thank you for your guidance.
