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
Most Valuable ProfessionalHey Anonymous ,
for me it looks like there is an error with Sharepoint Online.
That wouldn't require a gateway. Can you check if it works if you just use the Gateway for the on premises SQL Server and not for Sharepoint?
Hi Denis,
I have not added Sharepoint list to the on-premise gateway (although tried even with that). Independently, Sharepoint Online List based report and on-premise SQL Server database based report functions perfectly. Only for this report having data model with both as data sources cannot be refreshed at all.
Best regards,
Deb