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.
We have a user who created a whole PowerBI flow via a connection to data located within their OneDrive for Business folder on their C:\ instead of pointing the data to a Teams SharePoint source where the data actually exists. In PowerBI Desktop, I can rework the queries, but as many of you can imagine, this comes with some headache in terms of making existing parts of the query work with the new data source location. Does anyone have a cleaner way or a recommendation on how to cleanly repoint the PowerBI report to the new data source location? Thank you in advance.
Solved! Go to Solution.
You will have to swap out the first 1-3 lines of each query. You cannot change it using the datasource button. That only changes locations with the existing connector, not changing connectors.
I've done this before, and it is tedious, but doable.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @JMACND
As @edhans says you have to change the first few lines of each query to point to the new source location, but once you've done that, and perhaps one or two other lines to make sure you end up with the same table that is then used for the transformations in the query. None of the transform steps should need adjusting.
Regards
Phil
Proud to be a Super User!
Great @JMACND - glad you got it to work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi @JMACND
As @edhans says you have to change the first few lines of each query to point to the new source location, but once you've done that, and perhaps one or two other lines to make sure you end up with the same table that is then used for the transformations in the query. None of the transform steps should need adjusting.
Regards
Phil
Proud to be a Super User!
You will have to swap out the first 1-3 lines of each query. You cannot change it using the datasource button. That only changes locations with the existing connector, not changing connectors.
I've done this before, and it is tedious, but doable.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThis did work. I did have to change the line of code just below the inserted three lines to reflect the new naming convention of the injected source query lines.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |