The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I am trying to connect XMLA endpoint by using guest account, but can't make a conncetion. I can connect when i use my organization credentials but same string which i also shared with guest users( have different domain) does not work. I get the following error. Can anyone help please
Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Test.
===================================
The specified Power BI workspace is not found. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
Program Location:
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.ResolveHTTPConnectionPropertiesForPaaSInfrastructure(Uri& dataSourceUri, Boolean acquireAADToken, Boolean returnCloudConnectionAuthenticationProperties, String& paasCoreServerName, CloudConnectionAuthenticationProperties& cloudConnectionAuthenticationProperties)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenHttpConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Solved! Go to Solution.
@Anonymous wrote:
Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Test.
So if these users are from another domain the /myorg/Test part of the endpoint will try and connect them to a workspace called Test in thier Power BI tennant. You would need to replace "myorg" with your domain name. I don't have guest users I can test this with, but i think if you login with a user like person1@mycompany.com then you can use and endpoint like the following
powerbi://api.powerbi.com/v1.0/mycompany.com/Test
@Anonymous wrote:
Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Test.
So if these users are from another domain the /myorg/Test part of the endpoint will try and connect them to a workspace called Test in thier Power BI tennant. You would need to replace "myorg" with your domain name. I don't have guest users I can test this with, but i think if you login with a user like person1@mycompany.com then you can use and endpoint like the following
powerbi://api.powerbi.com/v1.0/mycompany.com/Test
@d_gosbell Thank you so much. Solution was perfect and it saved my lots of time.
User | Count |
---|---|
4 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
2 |