Forum

can I connect multi...
 
Notifications
Clear all

can I connect multiple power bi datasets in one report?

4 Posts
2 Users
0 Reactions
170 Views
(@yuanzhang0308gmail-com)
Posts: 31
Trusted Member
Topic starter
 

Dear,

I have currently connected with one power bi dataset (which is connected with a sql though gateway setup). Now I want to load another power bi dataset which is connected with another sql through gateway setup. It seems like not possible directly, everything is gray. Is there a work around for this?

image.png.a933bb0d261f34e013d69db083386c73.png

Thanks!

Br,

Yuan

 
Posted : 07/04/2022 10:05 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Yuan,

If you're using Direct Query then you cannot connect to any other datasets in the same model.

Mynda

 
Posted : 07/04/2022 10:35 pm
(@yuanzhang0308gmail-com)
Posts: 31
Trusted Member
Topic starter
 

Thank you for your reply Mynda. I found a solution changing a setting allowing preview settings, then it works.

 
Posted : 08/04/2022 6:47 am
(@mynda)
Posts: 4761
Member Admin
 

Great! In that case suspect you weren't using Direct Query

 
Posted : 08/04/2022 6:45 pm
Share: