Forum Discussion

powerbi_2022's avatar
powerbi_2022
Frequent Visitor
3 years ago

Datasources getting reverted in Power BI

Hello, 1. I had published reports in PowerBI workspace using MS SQL Server Datasource. 2. There was changes in Connection string so corrected 'source' in PBI report -> Published reports -> Mapped D...
Need Help
Tips and Tricks
jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

It is unusual for the changes you made to the data source connection string in Power BI Desktop to be reverted in the Power BI Service. Here are some possible reasons why the changes may have been reverted:

  1. If you are using Power BI Gateway, check if the gateway is running and configured correctly. If there is any issue with the gateway, it may cause the data source connection to revert to its initial state.

  2. If you have shared the report or dataset with other users, it is possible that they have made changes to the report or dataset that overwrote your changes.

  3. If you have configured automatic dataset refresh, it is possible that the refresh operation has overwritten your changes.

powerbi_2022's avatar
powerbi_2022
Frequent Visitor
3 years ago

What exactly you mean by 'Automatic refresh'? Is it different than scheduled refresh?