Forum Discussion
Can't Load Template Without Data
I made a report, and exported the template as .pbit type. When I load the pbit template into a blank report, it automatically starts the previous queries and loads the related tables. My understanding is that the point of the template is to strip any associated data. What's going on? FYI my data source is a dataflow.
Hi dustinb
The old data source information is stored in the template file. Since you have connected to these data sources from your computer before and the credentials are stored in your Power BI Desktop, it will connect to these data sources automatically when you open a template file or import a template into a blank report on the same computer. If you open it on another computer, it will pop up a window to let you enter the credentials to connect to these data sources.
If you want to change data sources, you can change it in Data source settings or in Advanced editor of Power Query. Reference: https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/
Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
4 Replies
Shouldn't I be able to import the template either way? Here is what I've tried:
- Import template in blank report
- Queries/tables from previous project are auto inserted
- Open new report
- Connect to xls data source
- Run query, load tables
- Import template
- queries and tables from previous project automatically overwrite current data
What am I doing wrong?
Hi dustinb
The old data source information is stored in the template file. Since you have connected to these data sources from your computer before and the credentials are stored in your Power BI Desktop, it will connect to these data sources automatically when you open a template file or import a template into a blank report on the same computer. If you open it on another computer, it will pop up a window to let you enter the credentials to connect to these data sources.
If you want to change data sources, you can change it in Data source settings or in Advanced editor of Power Query. Reference: https://www.c-sharpcorner.com/article/how-to-change-data-source-of-existing-report-in-power-bi/
Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
