Is it possible to click on the link and the Pdf file open in Power bi desktop ?

[ashmitp869]

Hi,
I have a report which has link to a pdf file.
Is it possible to click on the link and the Pdf file open in Power bi desktop ?

Thanks

[ullassl1991]

Hi @ashmitp869 please refer this document it may resolve your issue
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi... 

Thank you

[ashmitp869]

Hi @ullassl1991 
I tried your web url solution. But its not working when I Click on the link.
Its only redirecting to the link on a new tab
and the pdf is downloading when an "ENTER" event is occuring on the new tab.

Is there any way to skip the step i.e Clicking of ENTER.
The user would like to download or show the pdf when click on the report.

Any help will be appreciated. - 

The solution, to keep all PDFs in sharepoint folder and open in sharepoint is not possible as we are having InEight Documents to keep all documents not sharepoint.

[ullassl1991]

Hi @ashmitp869 I guess for Pdf files we can not visulize the file with in Power BI by clicking at the URL link, but there is an PBI visual which will take image URL and show it in Power BI by clicking at the URL,
one thing that can be done is, if PDF's are simple(single Page) means you can convert them to image formate and take that URL for visualization.

[ashmitp869]

Hi @ullassl1991 

Ok, I got that visualize is not possible.
But why its not dowloading at the first time when the URL is click.

I need to again press enter after redirecting to a new tab with that URL link.

[ashmitp869]

Hi @v-saisrao-msft 
Do you have recommendation.?

[v-saisrao-msft]

Hi @ashmitp869,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft · Accepted solution]

Hi @ashmitp869,

Thank you for your question. What you're experiencing is the default and expected behaviour.

In Power BI Desktop, hyperlinks open using the system's default browser, which may trigger a direct download depending on the file type and server response.

In contrast, the Power BI Service runs within a web browser environment, which handles link navigation differently. For files like PDFs, browsers often open the link in a new tab instead of downloading directly.

This behaviour is expected and is the default behaviour.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-saisrao-msft]

Hi @ashmitp869,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @ashmitp869,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @ashmitp869,
I wanted to check if you had the opportunity to review the information provided by @pankajnamekar25. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[pankajnamekar25]

Hello @ashmitp869 

You can keep all PDF into sharepoint folder and it can be open in sharepoint but, there is no way to open direclty in power bi

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[ashmitp869]

Hi @pankajnamekar25 , @v-saisrao-msft 
I am trying to load the pdf files from Sharepoint folder but getting errors like below

On step Detected Type Mismatches
let
tableWithOnlyPrimitiveTypes = Table.SelectColumns(Source, Table.ColumnsOfType(Source, {type nullable number, type nullable text, type nullable logical, type nullable date, type nullable datetime, type nullable datetimezone, type nullable time, type nullable duration})),
recordTypeFields = Type.RecordFields(Type.TableRow(Value.Type(tableWithOnlyPrimitiveTypes))),
fieldNames = Record.FieldNames(recordTypeFields),
fieldTypes = List.Transform(Record.ToList(recordTypeFields), each [Type]),
pairs = List.Transform(List.Positions(fieldNames), (i) => {fieldNames{i}, (v) => if v = null or Value.Is(v, fieldTypes{i}) then v else error [Message = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}})
in
Table.TransformColumns(Source, pairs)