Forum Discussion

BigKev's avatar
BigKev
Helper III
5 years ago
Solved

Combining multiple pbix data sets

Hi All,   I’m just wondering if it is possible to do this in the latest release of Power BI.   So currently, three developers are working on reporting 60 measures coming from different sources. W...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi BigKev 

    With the latest version of Power BI Desktop(Version: 2.91.884.0 64-bit (March 2021)), you can connect to multiple Power BI datasets. Calculated columns and Measures of these datasets will be reserved as the following picture. These Calculated columns will have icons as general columns. Measures will reserve their original icons. You can combine your pbix datasets by the feature.

     

    For how to connect multiple shared datasets, you can refer this official blog DirectQuery for Power BI datasets and its update in March 2021.

     

     

    Best Regards

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi BigKev 

With the latest version of Power BI Desktop(Version: 2.91.884.0 64-bit (March 2021)), you can connect to multiple Power BI datasets. Calculated columns and Measures of these datasets will be reserved as the following picture. These Calculated columns will have icons as general columns. Measures will reserve their original icons. You can combine your pbix datasets by the feature.

 

For how to connect multiple shared datasets, you can refer this official blog DirectQuery for Power BI datasets and its update in March 2021.

 

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.