Power BI embedded with SSAS directe connection

[Oussama]

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.

 

[Jaredk24]

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.

[Anonymous]

Hello, do we have any news from this?

thanks,

[Anonymous]

any ideas how to overcome this thing? direct query has serious performance issues.

[mikes2nd]

Take a look at this.

https://github.com/Azure/azure-content/blob/master/articles/power-bi-embedded/power-bi-embedded-app-...

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."

[Oussama]

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 ?

[mikes2nd]

https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-authentication-with-analysis-services-liv...

Take a look, it

[Mohamed]

Thank you Mikes, but will that work in Power BI Embedded?

[shay_cullen]

Hi,

Did this ever get solved?