Forum Discussion
Combining different PBIX dataset
- 3 years ago
Hi Madhumnair,
Yes, It's Possible !!
You can establish a live connection to a shared dataset in the Power BI service, and create many different reports from the same dataset.
----------------------------------------------------------------------------------------------------------------------
Step 1 - Open power bi report
Step 2 - Enable 'DirectQuery for power bi datasets and AS' feature in the power bi report.
To enable, go to File -> Options and Settings -> Options -> Preview features -> Select checkbox for 'DirectQuery for power bi datasets and AS' -> Click Okay.
Step 3 - Add Datasets into power bi report
Add Dataset of Report1 and Report2 one by one in the report.
In this way, we can use multiple datasets in the power bi report.
----------------------------------------------------------------------------------------------------------------------
Connect to datasets in the Power BI service from Power BI Desktop
If I answered your question, please mark this thread as accepted solution and just give kudos on this post ๐
Thank you !
Hi Madhumnair,
Yes, It's Possible !!
You can establish a live connection to a shared dataset in the Power BI service, and create many different reports from the same dataset.
----------------------------------------------------------------------------------------------------------------------
Step 1 - Open power bi report
Step 2 - Enable 'DirectQuery for power bi datasets and AS' feature in the power bi report.
To enable, go to File -> Options and Settings -> Options -> Preview features -> Select checkbox for 'DirectQuery for power bi datasets and AS' -> Click Okay.
Step 3 - Add Datasets into power bi report
Add Dataset of Report1 and Report2 one by one in the report.
In this way, we can use multiple datasets in the power bi report.
----------------------------------------------------------------------------------------------------------------------
Connect to datasets in the Power BI service from Power BI Desktop
If I answered your question, please mark this thread as accepted solution and just give kudos on this post ๐
Thank you !