SSRS Maps Issue: Bing Maps not loading in PBIRS/SSRS

SSRS Maps Issue: Certain people started facing this problem in SSRS/PBIRS where we are not able to load existing reports where maps are integrated. In this article I will give an idea where on how I fixed this issue. Recently I have faced this issue and the things which I tried to fix this issue are listed below.

SSRS Maps Issue

We will see different method in this article on how I tried to fix this issue please follow this step from method 1 for better resolution.

Error Details:

SSRS Map issue

Method 1

Check logs:

Go to SSRS log files and check if you get any kind of errors/statement. Sometimes we will have straight error on why this error is happening but in my case I did not any kind of error or problems in the log files.

Then I have enabled Verbose logging for PBIRS and checked for some error or exception but did not find anything. So, follow this below article TO ENABLE ADDIDTIONAL LOGGING in SSRS/PBIRS to get more in-depth details about the errors.

Link: https://kingfishertechtips.in/enable-verbose-logging-for-ssrs-pbirs/

Updates/Patches:

Why to upgrade?

All the features/bugs/updates will already be present in the newer updates/patches so once you download and install the latest patch/update it will by default enable the required TLS

Please check for any version upgrade or patch updates. If you are not sure what version you are currently using, then you can visit this below article for all list of versions and updates. You can also download directly from Microsoft Website.

Link to check versions:https://sqlserverbuilds.blogspot.com/2021/04/power-bi-report-server-versions.html

image 6

Method 2

Check the behaviors in Report builder, if you have power bi report builder or Microsoft report builder then open the same report and check whether it is working or not?

image 7

The reason why I am saying is because we need confirmation that the issue in either in the report or SSRS/PBIRS. Suppose if in the report builder it did not work out then problem could be something else.

Also please check this below document for any changes or updates in integrating the maps. If you don’t want to make any changes, please create one new sample file with this below document to check the behavior.

Link to create Maps: https://learn.microsoft.com/en-us/sql/reporting-services/tutorial-map-report-report-builder?view=sql-server-ver16

Method 3

You can also check by opening the report in Visual Studio SSDT tools and check whether it works or not? As you can see that I have opened the same RDL file in Visual Studio.

If you are not sure on how to open RDL/Paginated Report in Visual Studio, then you can follow this below article to install and configure SSDT tools.

Link: https://kingfishertechtips.in/ssdt-tools-report-tabular-cube-model-install/

Method 4

If you see in the below image the error message seems to be reading the connection problem and this error is not showing in the logs or verbose logs. Also, if you the ERROR message at the top and when we RUN the report which is integrated with Maps, we get error saying the same and if we search more then we come to know that at the backend SSRS/PBIRS will use TLS of different versions.

We follow this below Microsoft article to enable the TLS versions, the reason why suddenly it happened because Microsoft enrolled bulk disable or end of support for TLS lower version such as TLS 1.0 and TLS 1.1 etc.

  1. Beginning of this month Microsoft has clearly stated that TLS 1.0 and TLS 1.1 will be deprecated slowly with newer windows updates. SSRS/PBIRS follows these protocols in the backend. When we checked the TLS 1.2 by default disabled, so we have enabled by following this below document and the Maps started working without any issue.
  2. Since we are using SSRS old version, we will suggest you upgrade to latest version.

All the features/bugs/updates will already be present in the newer updates/patches so once you download and install the latest patch/update it will by default enable the required TLS.

Enable TLS?

Link to enable TLS: https://learn.microsoft.com/en-us/entra/identity/hybrid/connect/reference-connect-tls-enforcement

Open the above link and you can find this information in depth and shown below! This below image is for enabling TLS 1.2 through “Registry Editor.”

Enable TLS

Enable TLS PowerShell?

This below screenshot on how to enable through PowerShell script. Run PowerShell script with Admin Access and run this below command. You can find this below command by above link.

image 11

SQL Bi Links:

  1. Kerberos Issue: NT AuthorityAnonymous Login Failed -Resolve (kingfishertechtips.in)
  2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  3. RS.exe Utility: Migrate RDL Reports To Another SSRS/PBIRS (kingfishertechtips.in)
  4. Direct Query Mode ON In Tabular Model Issue – Visual Studio (kingfishertechtips.in)
  5. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  6. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  7. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  8. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  10. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  11. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  12. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  13. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  14. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  15. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  16. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  17. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  18. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *