cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DataScience42 Frequent Visitor
Frequent Visitor

Refresh failed after publishing PBI report to workspace (Power BI Service)

Hi all, 

 

I have a Power BI report consuming data from an API, and it works fine in Power BI desktop.

I wanted to publish the report to Power BI Service and create dataflow so that others in my organization can consume the underlying data, ,however, the dataset cannot be refreshed once the report is published to Power BI Service. 

 

I've tried to fix this issue by following some of the similar issues reported in this forum, but unfortunately none of them work. Thus it'd be much appreciated if someone can give me some hint to solve this issue.

 

And here is the error message I got.   

 

*********************Error Message********************

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

Please try again later or contact support. If you contact support, please provide these details.

  • MessageInformation is needed in order to combine data Table: ReportResults.

*********************End of Error Message********************

 

Some more background info

 

Subscription: Power BI Pro

Gateway: No gateway used for this particular report since data is extracted from external API

Data Source Privacy Setting: Orgnaizational

Other: The report contains queries that merge multiple tables and queries that invoke functions to consume data from the API

 

 

Thanks!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Refresh failed after publishing PBI report to workplace (Power BI Service)

hi @DataScience42 

What is the size of your PBIX file? The maximum size for datasets imported into the Power BI service is 1 GB and Power BI Service places a limit on the amount of uncompressed data that is processed during refresh to 10 GB.

If you still hit the above two limitations, you are not able to refresh dataset in Power BI Service. You can use DirectQuery/Live connection mode to connect to your data source instead, or purchase Power BI Premium license to solve this issue.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DataScience42 Frequent Visitor
Frequent Visitor

Re: Refresh failed after publishing PBI report to workplace (Power BI Service)

Hi @v-lili6-msft , 

 

Thanks for your reply.

Unfortunately, I don't think that's a size/compression constraint issue. The size of this PBIX file is less than 1MB.

Any other suggestions?

 

 

 

Thanks. 

 

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)