Unable to connect to the data source undefined.

[vinu]

Hi Team

We are currently having 4 dashboards and the schedule referesh is not working and receiving the below failure notifications.

Failure notifications.

Unable to connect to the data source.
Refresh failed:

 Dashboard has failed to refresh.
Failure details: 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.

Next refresh for Micare 2.0_Total Patient_Data Extraction is scheduled for December 10, 2019 3:00 UTC.

[v-eachen-msft · Accepted solution]

Hi @vinu ,

You could remove the broken reports from the service and re-add them.

1. Open the report(s) in Power BI Desktop and clear the cache (file...options and settings... options)

2. Refresh the data in the desktop and save.

3. Open Power BI Service and remove the associated dataset(s).

Note: you'll need to remove the reports from any content packs before you can remove the reports and data from the service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

4. Hop back to Power BI Desktop and publish the report from Power BI Desktop to Service

5. Hop back to Power BI Service and set the refresh schedule back up

6. Add the reports back into any apps or content packs.

[PaulMac]

Although this is marked as the Solution. This method unfornately doesn't work for me. 😞