Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
The refresh of the dataset in the Power BI service takes long. Having problems with SQL Profiler (not working yet) I looked at Query Diagnostics. I loaded my development dataset (being 5 queries all together) and performed the steps. In the end I get two datastes:
Aggregated and Detailed.
Read some on the internet, but since this is the first time find it hard to read those datasets.
Can somebody tell me which columns I should focus, which columns tell me where it goes 'wrong'?
And which rows I can ignore (for instance Resource is null?? ) ?
What do those categories like Evaluator,Preview etc tell me? Are they all important?
So, hoping a more experienced Query Diagnostic user can help me on my way.
Thnx very much
Ron
@PowerRon , Power Query transformation, Then Power Query calculated columns and then DAX calculated column
Try to load more data in the power bi desktop file and check which step takes lot of time to load in power query.
Usually, a Merge of tables can take time.
Hi @amitchandak how do I recognize Power Query transformation, Then Power Query calculated columns and then DAX calculated column?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |