Forum Discussion

Claster's avatar
Claster
Advocate II
8 years ago
Solved

Error when refresh data from PowerBI service

Hello, I have an error whe my model is refresh from PowerBI service, but whe i refresh model from power bi desktop I don't get error.
Need Help
  • Claster's avatar
    Claster
    8 years ago

    I found the reason, in some rows of the table there were dates 0001-01-01T00: 00: 00 I replaced them with null and model refreshed without error

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Claster,

 

Can you double check if you didn't cut part of the error message (see blue)? Is it full what you saw?

 

 

 

 

 

 

 

And to exclude memory issue. Can you go to Task Manager -> Resource Monitor (or press Win + r then paste perfmon.exe /res and press OK) 

*See other ways to run it - https://www.isunshare.com/windows-10/7-ways-to-access-resource-monitor-in-windows-10.html

 

Go to Memory tab, find all process with name msmdsrv.exe and click on each. 

Start you refresh in PBI Desktop and tell maximum values for Commit (KB) and Working Set (KB) until the end of a refresh.

resource monitor

 

 

 

zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Claster,

 

Another case when you can possibly have such issue if your version of PBI Desktop is old and not compatible with current PBI Service architecture. So I recommend you to uninstall the current version and install a new one. I can say it is really different, so give a try.