Forum Discussion
How to use 2 pbix files as source databases?
- Anonymous5 years ago
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.
- 5 years ago
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.
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.