Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I load a specific table from an ODBC connection. This same table has been migrated to Azure. How can I switch to Azure without having to rebuild the dashboard?
Thanks!
Solved! Go to Solution.
Hi @UsePowerBI - see my blog post below that explains how to swap out all of your transformations from one query to another when you change sources. Below explains how to do it with the Entered Data feature, but it will work from any data source to any other data source. The key is, you need to create your new data source and get it transformed to a point where the structure looks exactly like your old data source looked before you did any transformations. So usually it involves renaming columns and confirming data types are ok.
This is the same advice I gave you in Sept when you asked about moving Hadoop to Azure. Same concept.
See this article if you need help using this M code in your model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @UsePowerBI - see my blog post below that explains how to swap out all of your transformations from one query to another when you change sources. Below explains how to do it with the Entered Data feature, but it will work from any data source to any other data source. The key is, you need to create your new data source and get it transformed to a point where the structure looks exactly like your old data source looked before you did any transformations. So usually it involves renaming columns and confirming data types are ok.
This is the same advice I gave you in Sept when you asked about moving Hadoop to Azure. Same concept.
See this article if you need help using this M code in your model.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIn Power Query create a connection to the Azure data source that results in exactly the same output (*) as your original query. Once you have confirmed that the output matches exactly, copy the M code from the new query to the old query and delete the new query.
You may also get away with swapping the query names, but I have not tested that.
* if you don't do that you risk losing measures, groups, and more in Power BI.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |