Forum Discussion
How to replace Data Source for existing report?
Anonymous In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and chnage source.
go into Edit Queries. Find the table/query you want to change. Go to the first step in the Query (always called Source) and change it there.
Hi,
Simply, I want to have one PowerBI template that I can apply to multiple excel files and multiple sheets (i.e. excel files are the same except for sheet names and file names).
This does not work smoothly.
I have created a template with all the required queries and applied steps (i.e. remove rows, make row as column heading, change some collumn headings).
The issue arrises when I try to change the data source. There are a errors that arise and I cant seem to resolve them. Also, when i select the new data source the sheet name fails to change. (i.e. i change the "Source" and i change the "Navigation" to the correct sheet, however the sheet name on the left hand side of the screen does not update to reflect newly-selected sheet.)
Is the creation of a template and workflow (i.e. "applied steps") the right way to go about applying the same PBI file to multiple data sources?
I strong recommend you to create tables in your excel files.
That way you will not work with the sheets itself, but with the tables that you created.
Like that, you can work with multiple excel files.
Particularly, i've done this way so far.