Forum Discussion

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.

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

Memorable Member

8 years ago

1. Do you use Import mode?

2. How big is your PBIX file if you save this report on PC?

3. Are you Power BI Pro user?

4. Do you have Power BI Premium/Embedded capacity?

Advocate II

8 years ago

1. No

2. 14 Mb

3. Yes

4. No

My model stop refresh since 27 May.

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
  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.
- Claster
  Advocate II
  8 years ago
  
  I always use last version of PowerBI
  - zoloturu
    Memorable Member
    8 years ago
    Claster,
    
    Are you able to post your M query code here?

Related content