Forum Discussion

julianmbs's avatar
julianmbs
Advocate II
10 years ago

PowerBIClient.Datasets.GetGatewayDatasourcesAsync returns NULL

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....
Need Help
julianmbs's avatar
julianmbs
Advocate II
10 years ago

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

jocaplan-MSFT's avatar
jocaplan-MSFT
Microsoft Employee
10 years ago

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's avatar
    julianmbs
    Advocate II
    10 years ago

    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's avatar
      jocaplan-MSFT
      Microsoft Employee
      10 years ago

      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's avatar
        julianmbs
        Advocate II
        10 years ago

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