Forum Discussion
How to use 2 pbix files as source databases?
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.
Hi, Anonymous
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.
Sample:
See the links below for more information
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.
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)?
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.