cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
auglfc
Advocate I
Advocate I

Can't connect to multiple Power BI Datasets

I can't add more than one Power BI dataset to my report.

All datasets are in the same workspace and all created by me. I am able to connect to many Datasets in Excel, but not in Power BI Desktop.

Steps:

1. Create a new report and add a Power BI Dataset. 

2. Started adding another Power BI Dataset and get prompted to Add a Local model, then click on Add a Local Model and hit submit

3. Select a new dataset to add to the report, hit create, then submit, then I get prompted to login to my O365 account, which is odd since I'm already connected and just added another Power BI Dataset under the same workspace.

4. After I login with my credentials I got the error message: Unable to Connect We encountered an error while trying to connect. Details: "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."

5. I am able to add this same Power BI dataset if I add it first, but not able to add a second Power BI Dataset (either to a fresh report or an existing one)

auglfc_0-1650562829199.png

 

Your help would be greatly appreciated!

2 ACCEPTED SOLUTIONS
JamieS
Advocate I
Advocate I

I have logged this as an issue as it appears to be a bug with the Power BI software following an update: https://community.powerbi.com/t5/Issues/Can-t-connect-to-multiple-Power-BI-datasets/idi-p/2475115

 

Please upvote and let's see if they can offer a fix for this.

View solution in original post

auglfc
Advocate I
Advocate I

Seems like the issue has been fixed. Thanks everyone!

View solution in original post

8 REPLIES 8
auglfc
Advocate I
Advocate I

Seems like the issue has been fixed. Thanks everyone!

Sundaynero
Frequent Visitor

Just wanted to let you know that I just tried again and now it's working fine. I haven't changed anything in my settings so I guess that whatever was causing this error has been fixed by Microsoft.

Good luck.

JamieS
Advocate I
Advocate I

I have logged this as an issue as it appears to be a bug with the Power BI software following an update: https://community.powerbi.com/t5/Issues/Can-t-connect-to-multiple-Power-BI-datasets/idi-p/2475115

 

Please upvote and let's see if they can offer a fix for this.

Sundaynero
Frequent Visitor

I just noticed the same problem , seeing the same error message. I have a .pbix file in Direct Query mode connecting to several datasets stored in a Power BI Service workspace. Everything worked fine, but now I'm unable to add more datasets to the report.

Could it be this is due to the desktop update in April? Nothing else has been changed in this file nor in Power Bi service workspace.

Thank you.

yuvara
Frequent Visitor

I have the exact same issue. It was working perfectly last week. May be after updating to the latest version of Power BI Desktop, I am facing this issue

jennratten
Super User
Super User

Hello -  

To add the second you will need to do so using direct query and that has to be enabled for the tenant.  Do you know if that has been done?  Here is more information on that process as well as the capabilities and limitations and other solutions that may help you.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s... 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces 

https://community.powerbi.com/t5/Service/Can-a-Report-use-Multiple-Datasets/m-p/521624 

Thanks for replying, but I've looked at those articles before. 

The preview feature is enabled otherwise I wouldn't be able to go all the way to the end of the process of choosing the second dataset.

I am also able to do it in Excel (can add many PowerBI Datasets), but in Power BI I get the error message below when I'm adding the second dataset.

 

auglfc_0-1650572664876.png

 

 

 

 

Hi,

I am having the exact same issue as you here. It previously worked perfectly until this week, now it is resulting in the same error. We have also followed all steps in the articles suggested.

Could this be a wider issue with Power BI? The 'Unable to connect' message appears instantly so shouldn't be because the connection timed out. Also, the server and database name was generated automatically by Power BI so surely wouldn't be incorrect.

JamieS_0-1650625281402.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors