Forum Discussion

Anton2315's avatar
Anton2315
Regular Visitor
1 year ago
Solved

Power BI

Hello Guys, I have a client for whom I'm optimizing their report. This is the model :   My largest tables are inv_transaction_lines_by_day_store_document with 17 million rows and crm_sales_...
Need Help
Show and Tell
Tips and Tricks
  • Anton2315's avatar
    Anton2315
    1 year ago

    Hello,

    Thank you for your help.

    I have resolved the issue. I have made a separate table in SQL which is calculating everything because in Power BI there was no option to do it.

    Best Regards.

lbendlin's avatar
lbendlin
Super User
1 year ago

Use DAX Studio to evaluate the query plan and server timings for that query (ideally while connected to the semantic model in the Power BI Service).  Look out for excessive number of records - those may indicate unintentional cartesian products.  Refactor your query to apply filters/groupings earlier. ("reduce cardinality")

v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi Anton2315 ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!