Forum Discussion
Solved:Refresh fails online for report with data source:Sharepoint Online List + SQL server database
Hi,
Thanks to everybody for your tips in problem resolution. It helped me to narrow down to the actual problem while ticking the checklist.
The problem actually had been that I had used 'Merge Queries' to combine data from Sharepoint list and SQL Server database in the Power Query (Transform Data). It works perfectly in Power BI desktop, no problem with data model, reporting and data refresh. But when published, data refresh always failed. So the solution was not to use the 'Merge Queries' option in this case with data from different sources. Then everything worked fine both in Desktop and Reporting Services.
Best regards,
Deb
Hi,
Thanks to everybody for your tips in problem resolution. It helped me to narrow down to the actual problem while ticking the checklist.
The problem actually had been that I had used 'Merge Queries' to combine data from Sharepoint list and SQL Server database in the Power Query (Transform Data). It works perfectly in Power BI desktop, no problem with data model, reporting and data refresh. But when published, data refresh always failed. So the solution was not to use the 'Merge Queries' option in this case with data from different sources. Then everything worked fine both in Desktop and Reporting Services.
Best regards,
Deb
Have the same problem.
Unfortunately, I can't avoid merge