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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Yiyi
Helper I
Helper I

How to connect to multiple datasets in my workspace from PowerBI desktop?

Hello people, 

 

I have created several datasets in My Workspace by connecting directly to Azure Monitor Logs (I think they are live connection). I try to make a dashboard on the PowerBI desktop by connecting to all the datasets but after I connected to one via 'Get data' -> 'Power BI datasets', all options turn grey and I can not connect to the other ones. Do someone know if it is even possible to create a dashboard with several datasets in such a case? 

 

This is what the PowerBI desktop turned to after connected to one dataset from Power BI datasets: 

 

Yiyi_0-1689771363034.png

 

 

 

1 REPLY 1
rubayatyasmin
Super User
Super User

Hi, @Yiyi 

 

you can only establish a connection to one dataset per report in Power BI Desktop. Once you connect to one dataset, the other options indeed become grayed out.

 

how about using a dataflow? 

As your data is in multiple sources and you want to create a single dataset, consider using Power BI Dataflows.

 

or try using the composite model feature. 

 

or how about using PBI service? If you're creating a dashboard (as opposed to a report), and your datasets are in the Power BI service, then you can pull in visuals from multiple different reports (which can be based on different datasets) into a single dashboard.

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors