Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Changing Data source from MS SQL to Power Bi Dataset without recreating Report



We were using on-prem PBI Server and we are migrating to PBI service. We have mulitiple records connecting to MS SQL Server dataset ( MSSQLDS). As we are migrating to PBI service , we want to utilize the shared PBI dataset ( PBIDS )  , as there are lot of reports uses this dataset. The columns are identical between PBIDS and MSSQLDS. Tried adding PBIDS and renaming it to match it to MSSQLDS. Still , the reports does not work . it is looking for MSSQLDS. How do I change the datasource from MS SQL to PBIDS , without recreating reports from scratch?


Thanks in Advance. 

Community Champion
Community Champion

Hello @zahirmohideen ,


You could connect the SQLDB with on-premesis gateway


If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

Thank you for your response. Lot of reports are using the same data source. I can use MS SQL Server with no changes to the report. However , that will not be optimal.  I want to use Shared PBI dataset

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors