cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
walid140891
Helper I
Helper I

Published report doesn't refresh any more.

Hello,

 

We have a published report with different datasources (3 web api calls) and with incremental refresh settings which was working very well for several months.

 

However, we cannot currently refresh it and we started to see this error:

 

Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}}.

 

the refresh is working in the desktop app, I know it would be a solution to re-publish the report but it has the incremental refresh and we need the historical data we have.

 

We also didn't change any parameters or setting.

 

 

Thank you in advance.

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @walid140891 ,

 

As far as I know, you can refresh the old data in  incremental refresh in Powerbi Desktop. Reference related cases:Solved: Incremental refresh - changes in old data - Microsoft Power BI Community

 

According to the error message: "Information is needed in order to combine data", the following suggestions are provided:

workaround1:
If you are appending or combining two or more tables you should do it in a new query instead of the main query.


workaround2:
try the following steps:
1.Open .pbix report in Power BI Desktop
2.File - Options & Settings - Data Source Settings --> Clear All Permissions
3.[not sure if this does anything] File - Options and Settings - Option --> Clear Cache in "Date Cache Management" and "Q&A Cache Options"
4.Home - Refresh --> keep track of how you log into each data source. In my case it was 3 sources, all Organizational privacy levels
5.Save and Publish the report
6.Go to data source in the PBI service, and re-login to each of the data sources under Data Source Credentials --> make sure you are using the same privacy level as desktop app, in my case it was all Organizational
(Btw, this started with the latest version of Power BI Desktop so there is definitely a bug that resets privacy levels.)


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors