Forum Discussion
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_...
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.
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")
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.