Forum Discussion

julianmbs's avatar
julianmbs
Icon for Advocate II rankAdvocate 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
jocaplan-MSFT's avatar
jocaplan-MSFT
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Are you using SQL in direct query mode?

julianmbs's avatar
julianmbs
Icon for Advocate II rankAdvocate II
10 years ago

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

  • jocaplan-MSFT's avatar
    jocaplan-MSFT
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Advocate II rankAdvocate 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
        Icon for Microsoft Employee rankMicrosoft 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.