Forum Discussion
Change one drive data source and keep everything
In desktop, open the "Edit Queries" dialog box.
Click on the query in question.
In the "Applied Steps" box on the right Click the Gear icon
It will open a dialog box that has a browse option next to the file path.
You should be able to browse for a new file and keep all of the subsequent steps there. Every noe and then it duplicates some of the steps that Power BI Automates such as Promoted Headers and Changed Type so you may have to click the "x" next to those steps to remove the duplicate steps.
If this works please accept it as teh solution. I'm almost to my next badge 😁
Hi Anonymous ,
Try this:
1. Change data sources.
2. Clear permissions.
3. Apply changes.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
All steps go ok until i arrive to the step Expanded table column and voi la... error
An error occurred in the ‘Sample File’ query. Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table]