Forum Discussion
Fabric Plan PowerTable sheet unable to connect to SQL DB
Hello,
I'm having an issue with the new Plan item in Fabric. When I create a PowerTable and click on "Create a New App" I get this popup where I can select the connection and DB. The connection field is automatically populated and it is definitely an existing connection. Clicking "Connect" loads for a while but then throws an error saying "DTMS connection is deleted or not found".
In the Stack Trace there is a mention about the tenant ID not matching the tid claim. I have tried this with multiple different browsers and accounts (accounts with just a single tenant) but the error remains the same.
Any ideas what could be causing this? I checked the prerequisites for Plan and those are all OK.
Thanks,
Veikko
All right, apparently the SQL Database connection had to be created with an account that only has a single tenant. After that everything started working. Seems a bit strange to me so I would say this is a bug rather than the intended outcome? Especially since everything looks good in the UI but then gives an error when clicking "Connect".
1 Reply
All right, apparently the SQL Database connection had to be created with an account that only has a single tenant. After that everything started working. Seems a bit strange to me so I would say this is a bug rather than the intended outcome? Especially since everything looks good in the UI but then gives an error when clicking "Connect".