Forum Discussion

vitoridalgo's avatar
vitoridalgo
Frequent Visitor
5 years ago
Solved

Unable to render paginated report

Hello,   I am facing the below issue after publish SSRS in power bi premium.   This report use two data sources SQL On premise and analises services on premise too.   Ps.. In report builder it'...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Thank you very much for sharing the link, it helps a lot!

vitoridalgo's avatar
vitoridalgo
Frequent Visitor
5 years ago

Hi, v-jingzhang!

 

Thank you for your support!

 

In this article https://docs.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval is mentioned that complex data is not avaible to extract by pbi gateway.

 

"Because SQL Server is an on-premises data source, Power BI must connect via a gateway. The gateway, however, doesn't support retrieving data for complex data types. Complex data types include built-in types like the GEOMETRY and GEOGRAPHY spatial data types, and hierarchyid. They can also include user-defined types implemented through a class of an assembly in the Microsoft.NET Framework common language runtime (CLR).

Plotting spatial data and analytics in the map visualization requires SQL Server spatial data. Therefore, it's not possible to work with the map visualization when SQL Server is your data source. To be clear, it will work if your data source is Azure SQL Database because Power BI doesn't connect via a gateway."

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Thank you very much for sharing the link, it helps a lot!

    • JimTheBIGuy's avatar
      JimTheBIGuy
      Icon for Helper I rankHelper I
      5 years ago

      I looked at the link but this doesn't help. no special datatypes or gps type fields. We have parameters but that is the only unique item I can find.