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.
Hi,
I have a report with a data source from a MySQL server. Recently, I have migrated the data to a SQL Server 2014 and I don't know how to change the data source for Power BI without mess up the current file.
How can I do this?
Thanks in advance.
Solved! Go to Solution.
Hi @dbravo
An option to achieve this consists you need to change some code in "Advance Editor" inside Power Query.
On the ribbon: View --> Advance Editor
The window is similar to...
Here you can write your new SQL source.
I hope this helps
Regards
BILASolution
Hi @dbravo
An option to achieve this consists you need to change some code in "Advance Editor" inside Power Query.
On the ribbon: View --> Advance Editor
The window is similar to...
Here you can write your new SQL source.
I hope this helps
Regards
BILASolution
Hello,
Do we have to chnage the source for all the tables in advance editor?
or do we have any option to update this in bulk.
Thanks,
Nusrath
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |