Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |