topic Re: Help! in Power Query

Help!

Anonymous — Fri, 12 Apr 2024 11:19:41 GMT

Hi All,

Can hyperlinks to pdf files can be added to Power BI visuals?

For example, I have a lot of policies and procedures which is ongoing (writing stage), completed and planned listed in one table. And I'd like to link them as pdf files in cloud to document numbers in Power BI visual table, is it possible?

Re: Help!

BA_Pete — Fri, 12 Apr 2024 16:10:57 GMT

Hi Anonymous ,

Yes. Once you import your table of URLs into the data model, select the column of the table that contains your URLs, then change the Data Category to Web URL, which will allow them to be clicked as links when displayed in a table/matrix visual:

Pete

Re: Help!

Anonymous — Sat, 13 Apr 2024 02:23:11 GMT

Wow! BA_Pete thank you so much!

Re: Help!

Anonymous — Sat, 13 Apr 2024 03:23:44 GMT

I did, but links are not appeared in visuals

Re: Help!

BA_Pete — Sun, 14 Apr 2024 17:19:42 GMT

Make sure you add the full "https://" etc. to the URLs:

Pete

Re: Help!

Anonymous — Tue, 16 Apr 2024 06:06:48 GMT

Hi,

Thanks for the solution BA_Pete provided, and i want to offer some more information for user to refer to.

hello Anonymous , based on your description, as BA_Pete mentioned, you need to change your url text type to 'Web URL'first, and make sure the format is "https://......." .

then you want to link them as pdf files in cloud to document numbers, you can refer to the following steps.

1. click conitional formatting for the field , then select 'web url'

2.Select the url field.

Output

And you can refer to the following link about the hyerlink.

Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

If the solutions BA_Pete and I offered help you solve the problem, please consider to accept them as a solution.

Best Regards!

Yolo Zhu

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

Re: Help!

Anonymous — Wed, 17 Apr 2024 03:34:27 GMT

Anonymous Hello! Thank you for your detailed reply, but the problem is all those pdf files that I have to attach are in organizational cloud of the app that company uses to track them, so it's not satrting from http however hard I've tried to... how I can possibly solve it now?

Re: Help!

Anonymous — Wed, 17 Apr 2024 05:39:24 GMT

Hi Anonymous

Thanks for your quick reply, and after testing, if you want to display them, you need to put them to a website, or it cannot work, you can put the pdf to sharepoint or onedrive, then can use the url.

Best Regards!

Yolo Zhu

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

Re: Help!

Anonymous — Wed, 17 Apr 2024 07:12:47 GMT

Anonymous I'll try and keep you posted) thanks