Forum Discussion

Learner_SG's avatar
Learner_SG
Icon for Helper IV rankHelper IV
4 years ago

Refresh failure

Hi , I started to face  this refresh error from this week onwards in the power bi desktop and power bi service. I doubt whether it is due to growing size of the data. In any case ,I am unable to work...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Learner_SG , if you are a premium customer then enable XML end point.

Using the workspace URL open that in DAX studio and check the size of the model . You will also ger size of each table there.

 

Also, you can use SSMS to refresh the tables and find any show stopper table

XMLA Endpoint - Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI