Forum Discussion

jarthda's avatar
jarthda
Regular Visitor
5 years ago
Solved

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
 
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    5 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.