Forum Discussion

auglfc's avatar
auglfc
Advocate I
4 years ago
Solved

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. S...
Need Help
jennratten's avatar
jennratten
Super User
4 years ago

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-services 

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 

  • auglfc's avatar
    auglfc
    Advocate I
    4 years ago

    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.

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.