Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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, an...
  • Anonymous's avatar
    Anonymous
    5 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.

  • v-angzheng-msft's avatar
    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

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

     

    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.