Forum Discussion
Store Queries for Reuse?
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
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
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