Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |