Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I wanted to know if there is a quick and efficient way to connect multiple datasets from reports using Direct query into a common dashboard.
Is there an efficient way to achieve something like this.
Hi @Devjeet
Do you want to combine tables from multiple reports' datasets into a single table? You can connect to multiple Power BI datasets with DirectQuery. Then use UNION function to join multiple tables. However, this joined table will be in Import mode and it cannot be modified in Power Query Editor.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Devjeet , if they are power bi dataset, you can use direct query to the dataset.
You can create a power bi service dashboard
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |