March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello
i have a table that stores hyperlink paths that will open files in our work databases.
Is there a way to activate the hyperlinks in power bi?
Also is it possible to connect to the same file stored in our online ArcGIS site and use the map tool and open the hyperlinks when clicked in the map?
I can't test the map option just yet but I should be able too soon.
If the map option doesn't work than I'm hoping I can use the filter tools to be able to narrow down the stored paths and hopefully one would be able to click on the path and the files open.
thanks
Solved! Go to Solution.
Activate Hyperlinks in Power BI:
Note: Ensure that the data type of the column containing hyperlinks is set to "Web URL" in the Power Query Editor.
Using Hyperlinks in Maps:
Filtering and Opening Hyperlinks:
Regarding connecting to files stored in your online ArcGIS site, you would typically use ArcGIS Online or ArcGIS Enterprise for that purpose. If you have a web map in ArcGIS Online that includes hyperlinks, you can integrate it with Power BI to provide a combined experience. However, the specifics of integrating ArcGIS Online with Power BI would depend on your data and setup.
In summary, Power BI provides various options for working with hyperlinks, maps, and filtering to create a user-friendly experience for accessing files and information. To integrate ArcGIS Online with Power BI, you may need to explore ArcGIS integration options, and it's a good idea to consult ArcGIS documentation or support for guidance on that front.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ok thank you. I'm not seeing a text box option under the visualization "app" icons. I see insert text box.
My other issue is that there not URL's but paths with server names in front. It works this way in MS access. But I meant to say file paths with the full server paths. Do these not work, it has to be a URL?
I understand your concern. In Power BI, when you create hyperlinks using the HYPERLINK function or by directly entering paths, they should work even if they are file paths with server names in front rather than standard URLs. Power BI should be able to recognize and handle both types of hyperlinks.
However, there are a few things you should keep in mind:
Data Source Settings: Ensure that your data source settings in Power BI are configured to allow external links. Sometimes, Power BI might block external links for security reasons. You can adjust these settings in Power Query Editor by going to "File" > "Options and settings" > "Data source settings."
File Path Format: Make sure the file paths in your dataset are correctly formatted, and they point to the actual files on your network or server. Check for any typos or errors in the paths.
User Permissions: Ensure that the users who are accessing your Power BI report have the necessary permissions to access the files or resources specified in the file paths. If permissions are not set correctly, users might encounter issues when trying to open the files.
Testing: Test the hyperlinks in Power BI by clicking on them within your report. If the file paths are correctly formatted and accessible, they should open the associated files when clicked.
If you are still experiencing issues with file paths not working as hyperlinks in Power BI, it may be helpful to review your data source settings and the specific format of the file paths to ensure they are configured correctly for your environment.
I think what I'm finding from a google search is that power bi can't open a local file path. Or I assume one could copy the path then paste it.
But I'm still not seeing the actual text box under the visualations tool panel but I'll assume that the insert text box is the same thing?
You are correct; Power BI typically cannot directly open a local file path because of security and privacy considerations. It's not designed to open local files directly by clicking on file paths in a report. Users would need to manually copy and paste the file path into their file explorer or browser to access the file.
As for the "text box" issue, in Power BI, there isn't a specific "text box" visualization option like you might find in other tools. Instead, you can use the "Text box" feature, which you mentioned as "Insert text box." It serves the same purpose as a text box by allowing you to add text or information to your report.
Here's how to use the "Text box" feature:
In Power BI Desktop, go to the "Home" tab.
Click on "Text box" or "Insert text box."
You can then click on the report canvas where you want to add the text box, and a text box will appear.
You can enter any text you want into the text box, including explanations, instructions, or additional information.
You can format the text box by adjusting the font, size, color, and other formatting options from the "Format" tab.
While it may not be the same as a traditional "text box" in other applications, the "Text box" feature in Power BI allows you to add textual information to your reports effectively. It's commonly used for annotations, explanations, or adding context to your visuals.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you for all of the help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
87 | |
70 | |
61 |
User | Count |
---|---|
141 | |
122 | |
105 | |
94 | |
90 |