Forum Discussion

curiouspbix0's avatar
curiouspbix0
Icon for Helper IV rankHelper IV
6 years ago
Solved

Sharepoint Document ID

Hello Sharepoint PBI Users,   Am trying to locate where can I find the complete link of documents on sharepoint to load into Power BI estabilishing a link to launch from the PBI report. Folderpath...
Need Help
Show and Tell
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi curiouspbix0 

     

    the quotes  "" need to be around the URL, not the function, please refer to my post, why would you convert it to a table?

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi curiouspbix0 ,

Based on my test, If you want to open the file which stores in SharePoint folder with an URL link in power bi desktop, the URL link should be the shared link not like 'Foldpath + Name':

This link can be opened as an URL link in power bi desktop, the link like 'Filepath + Name' will download the file as you said previously. But it should be inconvenient because you should get the whole files share link manually as a table and import it into power bi desktop if you want to use URL to open it in power bi.

 

Best Regards,
Yingjie Li

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