Map visual in Power BI Report Builder and Power BI Server (Paginated Reports)

[sandeep0521]

Hi All,

I am trying to create a map visual in Paginated reports with county related values.

The report and the map visual are working fine in Power BI Report Builder. But when I publish the report to Power BI Service, I am getting the below error. 

Unable to load DLL ‘SqlServerSpatial 40.dll’. The specified module could not be found. (Exception from HRESULT: 0x8007007E

All the custom visual settings are enabled in Power BI admin portal.

Please let me know if there is any work around.

Thanks in advance

[amitchandak]

@sandeep0521 , is any other visual working. This seems like sql server issue. It is more related to desktop than service. But could be because of missing on-premise gateway details or Datasource credentials in case of cloud datasources 

[sandeep0521]

Hi Amit, Thanks for responding.
We have created a report with Column chart and it is working fine in both Power BI Report Builder and PBI Server. 
The database is SQL server and the PBI On-Premis gateway is up and running. We are facing the issue only with Map visual. Please let me know your thoughts, Thank you