Forum Discussion
Power BI embedded with SSAS directe connection
Hi,
I followed these steps here: https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-get-started-sample/
To embed a report with directe connection to an SSAS cube.
1) I successfuly create a workspaceId on the workspace collection (step 5)
2) I successfuly import a pbix file to the workspace (step 6)
3) I stuck on step 7, to update the dataset of the pbix file already uploaded
Witch value of parametres should I use: username, password, connection string ?
Where can I found the connection string of the PBI with SSAS ?
Thx.
8 Replies
Has anyone successfully published a report using SSAS and embedded?
We can not find any information on how this should be done and all the responses so for from MS folks are for SQL DW direct connections. Which does work but is very very different then authorizing against SSAS.
Take a look at this.
Once you get a grasp of that, look at mapping Azure AD, at the top the author states
"This design does not require your app to use Azure Active Directory for user authentication and authorization, although you can do this."
Hi dear,
Could you please be more clear. I am not a .NET developer, I just want to use the sample on th GitHub.
My report work fine when uploaded to Power Bi Service.
I guess that the Patch to update the datasource is already applied on the Sample code :
// Update the datasource with the specified credentials await client.Gateways.PatchDatasourceAsync(workspaceCollectionName, workspaceId, datasources.Value[datasources.Value.Count - 1].GatewayId, datasources.Value[datasources.Value.Count - 1].Id, delta);
My concerne is with the parameter I should use:
// Reset your connection credentials var delta = new GatewayDatasource { CredentialType = "Basic", BasicCredentials = new BasicCredentials { Username = username, Password = password } };I guess that user name and password are those used for my datasource on the Gateway.
The VS debugger shows a null value for datasources variable.
Should I enter a connection string ?
