PowerBI Report With Map

[noorahmad]

Hi folks

I have requirement to show map on PowerBi report with help of lat & lang but another requirement is once user drill down to a specific record/location, I have to show him a hyperlink from which will be in attached dataset and user clicks on the hyperlink to view the document associated with that particular record/location.

This possible to achieve in PowerBI.

Thanks

[GilbertQ]

Hi @noorahmad 

Yes this is possible.

What you will have to do is to build the Hyperlink as part of your data import process in Power Query. This will be a new column where you will build the hyperlink URL.

Then once you add the hyperlink to a table you can then give it the data category of Web URL.

Here are more details on how to complete this: Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Docs

[noorahmad]

I want this on the map not in the table, allowing user to click on a location and download the document.

[v-janeyg-msft]

Hi, @noorahmad 

According to your description, I made a sample to show you how to use web url in map,and it involves the knowledge of 'drill through'.

Like this:

Reference:Set up drill through in Power BI reports - Power BI | Microsoft Docs

Here is my sample .pbix file.Hope it helps.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[noorahmad]

@v-janeyg-msft thank you for responding. My drill through feature is also enabled on the map but I don't know how to add my attributes for it. My hyperlinks/files are in another table its like parent child. My map is attached to parent table and then we have child table which contains documents url for each record. Please check the screen shot.

[v-janeyg-msft · Accepted solution]

Hi, @noorahmad 

In my sample,I use name(in map) as the target of 'drill through', then drill through to the corresponding url. You can check my sample gif ,there is a clear process on it.

Drill through:Set up drill through in Power BI reports - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[noorahmad]

@v-janeyg-msft I am facing another issue in this report.

I have created/shared a PowerBI embed report (Below screen shot) and I needed filters on it. The filters are showing up in PowerBI service but when I tried to embed this report in Dynamics 365 Portal or even brower the embeded report I don't see the filter pane on right side. Is there some settings which needs to be enabled or am I missing something. Would really appreciate some help.

https://community.powerbi.com/t5/Service/PowerBI-Embed-Report-Not-Showing-Filters/m-p/1622329#M11905...

Could you please check this.

[v-janeyg-msft]

Hi,  @noorahmad 

If I solve your initial problem, Can you mark it as the solution to help the other members who have same problems find it more quickly? I will check other posts later, thanks.

Best Regards

Janey Guo