Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi,
Since the latest PowerBi Desktop update (April 2022), I'm unable to connect to more than one live dataset.
I'm getting this error after selecting the database/tables (for the second dataset connection) :
It's obviously not a timeout issue since I'm able to connect to the dataset if it's the first one that I'm connecting to.
Note that I can still open and refresh existing datasets containing multiple live dataset connections. Those were created in a previous version of Power BI Desktop.
Am I the only one getting this error?
Thanks
philqc77 when you say "live connection" do you mean, an actual LIVE connection or a DQ connection? Because an actual LIVE connection is always just to one source. If you're talking about DQ connections, please give some more details on what source you're using.
Sorry, maybe I'm not using the right terminology. Here's what I did:
1. I created a live connection to a Power BI Dataset (let's call it ds1). No problem there. 2. Then I wanted to add another connection to another Power BI Dataset (ds2). I got this prompt which I was expecting and I clicked on "Add a local model". 3. Clicked "Submit" on the following. This is related to ds1. 4. Selected ds2 and clicked on "Create" 5. Clicked on "Submit". This is for ds2 6. Then I got the login prompt which is unusual at this point. 7. Then I got the error. I did the exact same steps (using the same connection) on Power BI Desktop updated to dec 2021 and it worked flawlessly.
Hi thanks for sharing these details with me. I can reproduce a similar issue on my end. Looking at it now.
