PowerBIClient.Datasets.GetGatewayDatasourcesAsync returns NULL

[julianmbs]

Hi,

I am trying to embed Power BI reports (using Direct Query) in my ASP.NET application, and get "Can't display the visual" message. I understand that I need to patch my data source credentials.

I am using this sample to provision my workspace, import reports, etc. Everything works great, except option #7 "Update connection string info for an existing dataset". Line 544 returns NULL into datasources variable, even though all three parameters are correct:

// Get the datasources from the dataset
var datasources = await client.Datasets.GetGatewayDatasourcesAsync(workspaceCollectionName, workspaceId, datasets.Value[datasets.Value.Count - 1].Id);

Any ideas what could be the problem?

Thanks,

Julia

[jocaplan-MSFT]

Are you using SQL in direct query mode?

[julianmbs]

Yes, as I stated above, I am using DirectQuery mode.

[jocaplan-MSFT]

And SQL Azure? Getting null there means that your dataset didn't bind to any gateway. This should only happen if you are not using one of the supported sources.

[julianmbs]

It is SQL Azure. I have datasets for both SSAS and regular databases. When I upload the report to Power BI Online, it works fine, so the gateway is working.

[jocaplan-MSFT]

We don't support the enterprise gateway yet so the source must be in the cloud. This rules out SSAS and on premise SQL.

[julianmbs]

Ok, so SSAS is out for now. Then it should at least work with Azure SQL database? It's not on premise.

[jocaplan-MSFT]

Yep. That would working. We are currently working on adding support for the gateway. So SSAS will start to work in a little bit.