Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CloudMonkey
Post Prodigy
Post Prodigy

How to use 2 pbix files as source databases?

Hi All,

 

Please can you tell me how to create a pbix file that uses 2 other pbix files as data sources?

 

For the source pbix files: I have one pbix file that refreshes automatically nightly, and I have one pbix file that we refresh manually once per month (after the accounts have been finalised). Both are hosted on Service.

 

I have found this webpage https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets but it only refers to linking a pbix file to one single file via a Live connection.

 

Thanks for your help!

 

CM

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

Yes you could. You will have at the end a flow like this: Original Files > Dataflow > Dataset. Only constraint is that you should have a Premium Workspace, a Pro Licenser or Premium Per User to create a dataflow.

View solution in original post

v-angzheng-msft
Community Support
Community Support

Hi, @CloudMonkey 

 

Connecting PowerBI datasets with direct query allows you to connect multiple datasets.

in Power BI Desktop go to File > Options and settings > Options, and in the Preview features section, select the DirectQuery for Power BI datasets and Analysis Services checkbox to enable this preview feature.

vangzhengmsft_0-1625711417882.png

Sample:

vangzhengmsft_1-1625711759288.pngvangzhengmsft_2-1625711768609.pngvangzhengmsft_3-1625711812266.png

See the links below for more information

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
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

4 REPLIES 4
v-angzheng-msft
Community Support
Community Support

Hi, @CloudMonkey 

 

Connecting PowerBI datasets with direct query allows you to connect multiple datasets.

in Power BI Desktop go to File > Options and settings > Options, and in the Preview features section, select the DirectQuery for Power BI datasets and Analysis Services checkbox to enable this preview feature.

vangzhengmsft_0-1625711417882.png

Sample:

vangzhengmsft_1-1625711759288.pngvangzhengmsft_2-1625711768609.pngvangzhengmsft_3-1625711812266.png

See the links below for more information

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

 

Hope this helps.

 

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

Anonymous
Not applicable

Try creating a dataflow that uses as entities the datasets from Power BI Service, then in Desktop, import that dataflow using the Power BI Dataflow connector.

Thanks @Anonymous. Would I then be able to upload the pbix file to Service and have it run scheduled updates from other 2 pbix files on Service (via the dataflow of course)?

Anonymous
Not applicable

Yes you could. You will have at the end a flow like this: Original Files > Dataflow > Dataset. Only constraint is that you should have a Premium Workspace, a Pro Licenser or Premium Per User to create a dataflow.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.