Forum Discussion

gmbarrett1's avatar
gmbarrett1
New Member
5 years ago
Solved

Store Queries for Reuse?

New Power BI user coming from Qlik Sense. What is the best practice to leverage queries across multiple reports? In Qlik you could store transformed/aggregated data into optimized QVD files to be use...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi gmbarrett1 ,

 

Based on my test, you can connect to multiple datasets when using "DirectQuery" connection mode. And the tables from different datasets will be marked with different colors.

 

Reference: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

gmbarrett1's avatar
gmbarrett1
New Member
5 years ago

Thank you Icey . Good to know that you can pull them into the same report. Are you able to link and/or merge those different datasets within the report?