Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jarthda
Regular Visitor

How to switch data source in Desktop

I have my report .pbix definition currently connected to Azure SQL. I a have the same tables in a SQL instance. What is the best way to replace the connection but keep the report and tables? Is this possible?

Spoiler
 
1 ACCEPTED SOLUTION
mahimabedi
Responsive Resident
Responsive Resident

If you only want to change the connection string or point to a new SQL instance, then you can do it under data source settings as well.

mahimabedi_0-1603591221989.png

 

View solution in original post

2 REPLIES 2
mahimabedi
Responsive Resident
Responsive Resident

If you only want to change the connection string or point to a new SQL instance, then you can do it under data source settings as well.

mahimabedi_0-1603591221989.png

 

I'm not sure on the specifics of the connection steps in this case, but in general, you can change any data source as follows

 

1. Do not delete the current loaded table

2. Load the new table from the new source from scratch. Make sure the final table is identical to the original

3. In the new table query (2 above), go into Advanced Editor and copy all the code

4. Go into advanced editor for the original table (1 above) and paste the code from 2 in place of original code. 

take a backup copy first. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.