Power BI Desktop file as a data source  [Solved]

Used for anything related to the new Power BI Desktop and Service tools
PhilC
Posts: 219
Joined: Tue Sep 09, 2014 8:13 am

Power BI Desktop file as a data source

Postby PhilC » Wed Feb 06, 2019 10:34 am

Hi Matt, hoping you might guide me on this, I am looking to end up with a Golden Dataset approach. Was hoping there was a solution without looking at Dataflows as they are still in Beta, but if that is my approach will look into it.

Have posted this on the Power BI forum too
https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-file-as-a-data-source/m-p/616849#M294142

Here is what I posted

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

PhilC
Posts: 219
Joined: Tue Sep 09, 2014 8:13 am

Re: Power BI Desktop file as a data source  [Solved]

Postby PhilC » Tue Feb 12, 2019 11:53 am

Answer received from Support

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


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron