Published report doesn't refresh any more.

[walid140891]

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.

[v-henryk-mstf]

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.