Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
gmbarrett1
New Member

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 used in other apps and transformations. Is this possible in Power BI? For example, query_1 aggregates and groups data from one table and query_2 merges and transforms data from two other tables, all in one report. If I wanted to use those queries in other reports and blend them with other tables/queries, what is the best way to do this? I know you can do this upstream at the DW/ETL layer but obviously this requires experience and access there. From what I have read Dataflows can do this and save to CSV files, which sounds similar to how Qlik handles QVDs. Thank you in advance.

2 ACCEPTED SOLUTIONS

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.

multi dataset.JPG

 

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

 

 

Best regards

Icey

 

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

View solution in original post

Yes.  Please see this page/video for a good intro.

New composite models in Power BI: A milestone in Business Intelligence - SQLBI

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

5 REPLIES 5
mahoneypat
Microsoft Employee
Microsoft Employee

Yes.  You can create Dataflows or publish reports which will create a dataset with it that can be used to create other reports.

Introduction to dataflows and self-service data prep - Power BI | Microsoft Docs

Create reports based on datasets from different workspaces - Power BI | Microsoft Docs

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Can I blend two datasets in one report?

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.

multi dataset.JPG

 

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

 

 

Best regards

Icey

 

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

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?

Yes.  Please see this page/video for a good intro.

New composite models in Power BI: A milestone in Business Intelligence - SQLBI

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors