Forum Discussion
Refresh Failure - Datasources: CDS/Dataverse and local SQL Server
Hi Community -
I have a report that has historically been just data from a local SQL datasource, refreshing normally via enterprise gateway.
We recently got CRM Dynamics 365 and I have merged some data into the file using DataVerse/CommonDataService.
The file refreshes normally via the desktop but now fails in the service (The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support).
I have other reports that refresh using DataVerse just fine, though none that use multiple datasources like this one does, the other reports are just Dynamics-Only.
Relevant workflow info: I imported 3 tables from Dynamics and then merged them into my SQL source table as I only needed a couple fields from them. Is this my issue? Can you not merge CDS data and local SQL data togther? While I try to figure this out I have been manually refreshing the desktop PBIX file and then pushing it out to the service again so users can have fresh data.
I also have enabled the checkbox on the gateway about allowing users' cloud sources to refresh with no luck.
Fixed my own problem by doing a Save As and publshing a whole new Report with the same file.
Everything refreshes just fine now.
So I am assuming there was some kind of caching issue with my old report where the data sources were not updating with my changes. Hopefully this info helps someone else. Kind of a pain for users to have a new URL/re-add to favorites but better than refresh being broken.
1 Reply
Fixed my own problem by doing a Save As and publshing a whole new Report with the same file.
Everything refreshes just fine now.
So I am assuming there was some kind of caching issue with my old report where the data sources were not updating with my changes. Hopefully this info helps someone else. Kind of a pain for users to have a new URL/re-add to favorites but better than refresh being broken.