cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PhilC Regular Visitor
Regular Visitor

Power BI Desktop file as a data source

Hi,

 

I have a monthly reporting process and currently use PQ in Excel to extract a snapshot of the data at month end.  This file (Snapshot) is then kept static and used as a source for a second Excel file (Model), where substantial processing and measures are created.  I refresh the Model multiple times as have parameters to filter out different aspects of the data.

 

I want to move to using Power BI for both aspects of this process, but cannot work out how to have the Snapshot Power BI file become the source for the Model Power BI file.

 

Using Live Connection prohibits adding additional tables (which are needed for the processing component) and I do not want the users to have access to the Snapshot file, so it needs to be in a separate Workspace.

 

One aspect around this is that I want to be able to play around and develop the Model, refresh the reporting tables to update the changes, without refreshing the underlying data, ie maintaining the Snapshot as at the end of the month.

 

Is there a way to use a Power BI file as a source for another Power BI model?

 

Cheers

Phil

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

Re: Power BI Desktop file as a data source

Hi @PhilC,

 


Is there a way to use a Power BI file as a source for another Power BI model? 

No. It is not supported to use a .pbix file as a data source for another Power BI data model. You could submit ideas here.

 

Besides, Incremental refresh in Power BI Premium might meet your requirement in some aspects.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: Power BI Desktop file as a data source

Hi @PhilC,

 


Is there a way to use a Power BI file as a source for another Power BI model? 

No. It is not supported to use a .pbix file as a data source for another Power BI data model. You could submit ideas here.

 

Besides, Incremental refresh in Power BI Premium might meet your requirement in some aspects.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PhilC Regular Visitor
Regular Visitor

Re: Power BI Desktop file as a data source

Hi @v-yulgu-msftYuliana, thanks for the response.

 

Would you suggest DataFlows as an appropriate approach to achieve what I am after?

 

Cheers

Phil

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)