Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data gateway support for paginated reports

hello,

I'm just curious if paginated reports support connections through data gateway?

As currently I'm trying to PoC such solution but without success.

Need Help

13 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-danhe-msft, thanks for the replay unfortunately I can't find this to work.

      Currently I have solution wit multiple "standard" reports (.pbix) and with them everything is fine it can reach datasources (in Azure) behind data gateway and now I'm trying to introduce paginated reports and here comes problem as even when I try to connect to data source I get an error: 

       

      Failed to update data source credentials: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)Hide details

      Activity ID:9f11e9be-0178-4be0-a72c-4be05e010e83
      Request ID:a787815d-cd7c-bae7-483c-cac5e8872883
      Status code:400
      Time:Mon Mar 18 2019 10:01:52 GMT+0100 (Central European Standard Time)
      Version:13.0.8730.162
      Cluster URI:https://wabi-west-europe-redirect.analysis.windows.net

       

      db is in azure (sql managed instance)

      report configuration is:

      connection type: 

      Microsoft Azure SQL Database

      connection string:

      Data Source=<server url> Catalog=<db name>

      credentials are also correct connection works fine with Report Builder but not after deploying to Power BI Service.

       

      Can you give me some hint what I'm doing wrong maybe I should update connection string somehow?

       

      Best regards,

      Michał

      • rpatkar's avatar
        rpatkar
        Icon for Power BI Team rankPower BI Team
        7 years ago

        Hi Michal,

         

        I don't think we have tested this scenario of using SQL Managed Instance through Gateway. Why are you trying to use GW here rather than connecting to it directly. Asking since GW is primarily a means to enable on-prem data sources to be used in cloud scenarios.

        Also, if you have created a Power BI Dataset using this data source (you likely have this as part of uploading the PBIX report you created), you can have your Paginated Report connect to this Power BI Dataset through the XMLA endpoint. https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/. In Report Builder, use "Microsoft SQL Server Analysis Services" as the data source. Thanks.