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
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.
Solved! Go to Solution.
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.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Yes. Please see this page/video for a good intro.
New composite models in Power BI: A milestone in Business Intelligence - SQLBI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe 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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |