Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue with refreshing the Power BI

Hi, I have been constantly getting errors refreshing the Power BI report which is connected to a SQL server in a semantic model. The size of the report is approx 600mb. The report tries refreshing...
Need Help
aj1973's avatar
aj1973
Community Champion
2 years ago

Hi Anonymous 

In the Table : de_transaction , do you have calculated columns?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Yes I do
  • aj1973's avatar
    aj1973
    Community Champion
    2 years ago

    Calculated Columns and Calculated Tables need to be avoided as much as possible. Add Calculated only when it is necessary to use as a filter category for exemple.

    So go back to your desktop and start analysing which one is causing the Time out and replace it or replace all of the calculated columns by Measures.