October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi,
I have been trying to use the ALM Toolkit, and have successfully used it to compare models within two Power BI Desktop files, however I am struggling with the option to connect this to a workspace.
When inputting the connection string provided by the service, I receive the error below:
Can someone advise what I may be doing wrong?
Thanks
Solved! Go to Solution.
After a little more digging, I discovered this was related to a tenant setting under Integration Settings in the Admin portal.
'Use Analyze in Excel with on-premises datasets' must be enabled. I've enabled this in our tenant settings and can now successfully connect using the method above.
Hi @Anonymous ,
You need to use correct dataset string, you could copy dataset string in dataset setting like below
powerbi://api.powerbi.com/v1.0/myorg/<workspace name>
Then it will prompt credential windows, you need to sign in, then you could choose dataset name in that worksapce. This seems work in premium workspace.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dax
I managed to get as far as signing in, prompting for credentials etc. It's right after this that I get the error message. Notably I've also noticed a similar error when I tried to connect using other tools like SSMS with the workspace connection string. Is there a tenant setting somewhere I've missed perhaps?
The workspace is assigned to Premium capacity, and the XMLA Endpoints for the capacity is set to read/write - though I'm not intending to write to it just yet, only wanted to test the comparison functionality.
After a little more digging, I discovered this was related to a tenant setting under Integration Settings in the Admin portal.
'Use Analyze in Excel with on-premises datasets' must be enabled. I've enabled this in our tenant settings and can now successfully connect using the method above.
User | Count |
---|---|
98 | |
98 | |
91 | |
76 | |
40 |
User | Count |
---|---|
146 | |
129 | |
125 | |
90 | |
56 |