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
Anonymous in manage your gateway settings, for this gateway, make sure the below is selected...
Hi ranbeermakin,
I checked that those options that you named are already selected.
But, then I saw this asking for gateway update to a newer version. So, maybe the gateway update would help resolve the problem. Although I still doubt then why the other datasets using this gateway are getting refreshed successfully.
However, ranbeermakin and selimovd , it was relieving to know that creating a data model from sharepoint online list + on-premise sql server database is then supported even in Power BI Report Services.
I will update the issue here once gateway update is done after approval. Thanks to both of you.
Regards,
Deb