Data Source Update

[rajuj]

I have updated the data source from SQL Server A to SQL Server B and republished the report. Since then the scheduled refresh throwing an error "internal service error" and on demand refresh doing the same thing. When I create a new workspace and publish the report and it is working fine. Anyone has experienced this? I hate to republish all the reports in the new workspace.

[Anonymous]

Hi @rajuj ,

I think you need to re-configure your data source settings after you change and re-publish your report. Can you share more detail information about these operations?

Regards,

Xiaoxin Sheng

[rajuj]

I did re-configured data source settings and cleared the cache (suggestion from other blog) and re-publish the report. However I was getting the same error during the on-demand and schedule refresh.

Something went wrong

The last refresh attempt failed because of an internal service error.
Please try again later or contact support. If you contact support, please provide these details.

Cluster URIWABI-WEST-US-redirect.analysis.windows.net

Activity ID8a18000d-1043-44a2-a7bf-2820eda82856

Request ID77371f68-c9ee-1e5f-c9db-694ad8e5a41d

Time2019-04-02 20:05:25Z

When we tried to create a new workspace and published the report and refresh works fine. However we doesn't want to do that since it was time consuming. We found the work around to re-publish in the same workspace with minimal changes, changed the file name and deployed and refresh worked (not as bad/time consuming as deployed in a new workspace). I am still looking for the reason behind the underlying issue. 

[Anonymous]

Hi @rajuj ,

I try to trace your activity id and find out below error messages:

Flow step ProcessDatabaseFlowAsync had an exception: FabricIntegratorDatabaseNotBoundException
The Fabric Integrator failed to unbind a database '' because it was not bound to any service.

I'd like to suggest you open a support ticket with these details error messages, it is free for pro and above license.

submit a support ticket

BTW, you can also refer to following link to parametrize your connection string, then you can change it on power bi service side:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev

Regards,
Xiaoxin Sheng