cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

PowerBI Service data refresh: The command has been canceled

Hi

 

I have a PowerBI report which uses Cosmos DB and few local server xlsx-files. The report works fine in Power BI desktop and when I refresh the report in Desktop, everything works fine and no errors in the data. Also, there are no custom columns or measures which are not working. So everything is fine in the Desktop side.

 

But, when I publish the report to the BI Service and try to manual refresh / auto refresh the data, the report gives has started to give me errors:

 

"There was an error when processing the data in the dataset.

Message: The command has been canceled. Table: Contract"

 

The error message is always the same, BUT, sometimes it changes the Table where it refers to. I cut one 1 to * relation in the model just for a test, and now it refers other table, theContract table.

 

I have like 10 tables from CosmosDB and some query steps involved. I made some optimization to the queries (deselect unnecessary columns etc), but no luck.

 

This again is driving me nuts, because when I demo the report in Power BI Desktop, many reports work fine, but when I try to autorefresh the data in the Service using The Great Cloud Data (Cosmos DB), it does not work.

 

I also tried to solve the problem by naming the report and publishing it, but no luck. Same errors.

 

Any idea dear Power BI gurus? We have 'a great situation' in this environment, because at this moment we don't have an actual DW, but just a connection to the live ERP CosmosDB data.

 

BR,

The lurking controller who misses SQL on-prem data.

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: PowerBI Service data refresh: The command has been canceled

Hi @attehaa

Do you use Azure Cosmos DB connector in Desktop?

How about using only the few local server xlsx-files as a test, does this can be refreshed successfully in Power BI Service?

Do you have configured a gateway to connect to the data source?

See a similar thread.

https://community.powerbi.com/t5/Service/Making-a-auto-refresh-Power-BI-report-using-Azure-DocumentD...

 

Best Regards

Maggie

Highlighted
Helper II
Helper II

Re: PowerBI Service data refresh: The command has been canceled

Heya

 

Yeah, pretty sure it's just our current Azure subscription and the heaviness of the queries. Need data lake naow.

Highlighted
Frequent Visitor

Re: PowerBI Service data refresh: The command has been canceled

 I'm hitting this exact same issue. Did you find any resolution?

Highlighted
Helper II
Helper II

Re: PowerBI Service data refresh: The command has been canceled

Nope.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors