Error when refresh data from PowerBI service

[Claster]

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.

[Hardik]

https://community.powerbi.com/t5/Integrations-with-Files-and/The-command-has-been-canceled/td-p/2494...

I hope this helps

[Claster]

I have Odata connection string and only one data source

[Claster]

Any ideas? My model don't refresh 😞 

[zoloturu]

Hi @Claster,

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?

[Claster]

1. No

2. 14 Mb

3. Yes

4. No

My model stop refresh since 27 May.

[zoloturu]

@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

[Claster]

I always use last version of PowerBI

[zoloturu]

@Claster,

Are you able to post your M query code here?

[Claster]

I use import data from Odata. I can't understand what error in the model. When I open a model i have some error

[Claster · Accepted solution]

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]

@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.