The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
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
I want this on the map not in the table, allowing user to click on a location and download the document.
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.
@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.
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.
@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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
36 | |
33 | |
23 | |
14 |