Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chris-F
Frequent Visitor

Paginated Reports Geospatial Data Issue in Service?

Hi

 

I am trying to transfer over an SSRS report into a paginated report to run on the Power BI Service. I have migrated a bunch of SSRS reports to Paginated, but the one I am stuck on uses a map. It has an SQL datasource, which has a geography field that looks like "0XE610000000010C51DD............". The report runs on our SSRS server, as well as our Power BI Report Server, but when I upload it to the Power BI Service, I get a lengthy "Null Key" error, but none of the keys are null. I have tried taking out the map, and just putting an expression to pull the first "Geography" field, and it still gives me the same error. As soon as I get rid of the geography field in the report, it works again. Would anyone have any insights into this?

2 REPLIES 2
WheresWally
Helper III
Helper III

It's because PowerBI gateways don't support complex data types of which geo is one. There's no published solution except to use a map visualisation in a regular powerbi report with lats and longs instead of geo data. OR use an azure database which doesn't require a gateway. 

 

See here:  https://learn.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval#sql-server-compl...

bradsy
Employee
Employee

No insights, but this might be a good one to file an issue for. Migration from on-prem to service we are trying to make as seamless as possible for all the supported features.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors