Power BI Desktop file as a data source  [Solved]

Used for anything related to the new Power BI Desktop and Service tools
Posts: 274
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

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?


Posts: 274
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

Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 2 guests