geospatial datatypes - error in Power BI Paginated report on web service

[sonalidhar87]

Do we have any limitation for geospatial datatypes in Power BI Paginated reports on web service. I am getting below error when publishing a report

[v-chenwuz-msft]

Hi @sonalidhar87 ,

Is your data source sql service? If yes, SQL Server is an on-premises data source, however, doesn't support retrieving data for complex data types. You can consider to user Azure SQL Database, this does not need a gateway.

For more details you can refer this article:

Data retrieval guidance for paginated reports - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.