Forum Discussion
Unable to connect to the data source undefined.
- 6 years ago
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.
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.
Although this is marked as the Solution. This method unfornately doesn't work for me. 😞