Forum Discussion

sk's avatar
sk
Microsoft Employee
10 years ago

get data from files on a sharepoint site

Hello,

i have built a powerbi report with some excel files, which are located on my personal OneDrive for Business.

Now i want to make these files also availabla for my team. I thougt about putting these excel files into a sharepoint site and want to connect these files on the sharepoint site with my current PowerBI report.

 

Has anyone experience in getting data from a sharepoint site?

 

Thank you in advance

Serhat

Need Help
Show and Tell

4 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    sk I haven't used sharepoint data sources but there are number of connectors available for sharepoint data sources.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • DAN's avatar
    DAN
    Advocate II
    10 years ago

    Hi sk,

     

    You don't need to open in excel online, you can click on "..." then select "Get a link". Copy the one marked "Restrict link" in the selection list (the others link do not work)

     

    Kind regards,

     

    • sk's avatar
      sk
      Microsoft Employee
      10 years ago

      thanks Dan for your reply!

       

      i tried this with the restricted link and it does not work. I get the notification that the URL is not valid.

       

      Regards