How to connect a online PFD report to power bi

[jwi1]

Good day,

I have a pdf file, which is stored on my companies sharepoint.

My question is: how can I add this pdf file to my power bi report?

If it is an excel file, this can be done via GET DATA (the excel file-URL is copied from file/ info/ copy path).

Thanks upfront for your help!

John

[MFelix · Accepted solution]

Hi @jwi1 ,

In this case you can do the same thing has you can see in the images below I have connectec to a sample PDF online trough a web link:

Has you can see ni the code below the first step assumes the PDF conversion:

let
    Source = Pdf.Tables(Web.Contents("http://www.africau.edu/images/default/sample.pdf"), [Implementation="1.2"]),
    Page1 = Source{[Id="Page002"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Page1,{{"Column1", type text}})
in
    #"Changed Type"

[v-yalanwu-msft · Accepted solution]

Hi, @jwi1 ;

You also could get data then select sharepoint-online-list . 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

https://community.powerbi.com/t5/Desktop/Difference-between-Sharepoint-list-vs-Sharepoint-Online-Lis...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix · Accepted solution]

Hi @jwi1 ,

In this case you can do the same thing has you can see in the images below I have connectec to a sample PDF online trough a web link:

Has you can see ni the code below the first step assumes the PDF conversion:

let
    Source = Pdf.Tables(Web.Contents("http://www.africau.edu/images/default/sample.pdf"), [Implementation="1.2"]),
    Page1 = Source{[Id="Page002"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Page1,{{"Column1", type text}})
in
    #"Changed Type"