Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
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.
Microsoft EmployeeHi thanks for sharing these details with me. I can reproduce a similar issue on my end. Looking at it now.
- jeroenterheerdt
This is a known issue at this point and has been fixed - we will release an update soon. It only affects datasets in Pro workspaces.
- rjs2
Resolver I
Do you know when this will be fixed for the Pro workspaces? Is there a work around?
- jeroenterheerdt
I cannot give you a timeline yet, but rest assured this will be updated for Pro workspaces as well. There is no workaround.
Thanks for looking into the issue. Even I am having the same issue. Trying to connect 2 PBI datasets.
In the old reports which had combined PBI datasets, I am unable to establish relationship betweeen tables from different data sets. Seems this issue will get fixed alongwith the earlier reported issue.
