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 😁
I have done this multiple times with no problem. I assume you are doing it in Power BI Desktop. You can't change the file path in the gateway or Power BI Service. So you will have to change all of them in Power BI desktop, republish the file, and then update the credentials in the Gateway.
I suggest using the browse function when changing the source instead of just trying to type the change in the query editor to make sure it is completely correct.
If this works for you please accept it as the solution.
this is the 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]
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 😁