Unable to Connect to the data source in Power BI Service

[fssebastian]

Hi, 

Currently, we're having an error with the scheduled Refresh. It works fine before, but the scheduled refresh suddenly have an error saying that we're unable to connect with the data source.

we're able to connect with the data source in Power BI Desktop. So our workaround is to manually refresh the report in the Power BI Desktop then Publish it for now..

How can we solve this error?

[v-xiaotang]

Hi @fssebastian 

Thanks for reaching out to us.

what's your datasource? 

>> 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.

I find a post about this error, please refer to Solved: Refresh Failed - Internal Service Error - Microsoft Power BI Community

"

The solution in my case was to remove the broken reports from the Online service and re-add them.

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

2 - Refresh the data in the desktop and save.

3 - Open PBI Online 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 online 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 PBI Desktop and publish the report from PBI Desktop to Online

5 - Hop back to PBI Online and set the refresh schedule back up

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

" -- by NeilBarrett

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[bcdejesus]

Hi @v-xiaotang ,

Also encountered the same error.

I also followed the steps presented by NeilBarrett but still same error persists. Is there any other solution to fix this problem? 

Thank you.