cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dustinb
Frequent Visitor

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.

1 ACCEPTED SOLUTION

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.

View solution in original post

4 REPLIES 4
VijayP
Super User I
Super User I

@dustinb 

When you are using Pbit file you need to first connect to the current data and then start working!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


dustinb
Frequent Visitor

Shouldn't I be able to import the template either way? Here is what I've tried:

  1. Import template in blank report
  2. Queries/tables from previous project are auto inserted

 

  1. Open new report
  2. Connect to xls data source
  3. Run query, load tables
  4. Import template
  5. 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.

View solution in original post

Hello @dustinb ,  @v-jingzhang ,

 

I am not attempting to provide an answer, so please bear with me.  I believe  I have experienced been through the pain and hence my interest.

 

I think, the question can be interepreted in 2 ways:

  1. When I open a Power BI template using Power BI Desktop, why does it always fetch data from the underlying data source? (I just want to open the template and view the design, so why do a long connection)
  2. When I open a Power BI template using Power BI Desktop, how do I specify the connection parameters of the underlying data source?

I think Question 1 is a limitation of the product. Power BI needs "some data source" and use the data source +template combination to create a PBIX.

 

I think Question 2 can be addressed easily via parameters. 

 

Thanks,

Sau

 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors