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
Community SupportHi Anonymous ,
Has your question solved?
The following reason may cause gateway refresh error：
1. Data loading is parallel by default, when PowerBI needs to refresh many Query, refreshing all of them may cause PowerBI to occupy too much system memory and error occurs
2. The gateway may not be the latest version
3. The data source may be missing or changed
4. Unsupported data sources may be refreshed
5. Password changes or expired credentials can cause data refresh failure
6. The desktop version may be out of date due to a problem with the M script in the Power BI Desktop file or Excel workbook
7. The amount of uncompressed data imported is too large to exceed the 1GB limit
8. Problems with Gateway, may be no access, offline, unable to log in, outbound port has abnormalities, etc.
9. Data source definition may be wrongly written
Refre:
Troubleshoot gateways - Power BI
Wish it is helpul for you!
Best Regards
Lucien