Forum Discussion

Pateen's avatar
Pateen
Icon for Helper I rankHelper I
7 years ago
Solved

Connecting PowerBI to a SharePoint Folder

Hi, I am trying to connect to my organisations’' SharePoint account so I can retrieve CSV files as a Power BI data source. I am using a SharePoint URL (i.e. https://mycompany.sharepoint.com/sites/G...
Need Help
Show and Tell
  • Minseven's avatar
    Minseven
    7 years ago

    If you can see it (screenshot) you can access it!

    click Edit. In new screen > filter by your file names (Thats's why naming your data is important here) > Then combine your file:

     

     

     

  • Pateen's avatar
    Pateen
    7 years ago

    Thanks you Minseven 

     

    That works perfect

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Pateen ,

 

Please refer to my reply in this thread.

 

Regards,

Yuliana Gu

  • Pateen's avatar
    Pateen
    Icon for Helper I rankHelper I
    7 years ago

    Hi v-yulgu-msft 

     

    Thanks for the reply.
    I had a look through the thread and tried a few options such as try using the link from Windows Explorer, however the windows explorer is disabled in my classic view.

    The thread you send appears to be more about merging multiple fields within a folder. My problem is much simpler; I just need access to the folder in the first place that I can already see in SharePoint.

    One thing I noticed is I do have visibility to the base site i.e. https://mycompany.sharepoint.com. However, I cannot navigate from there.

    Pat

      • Pateen's avatar
        Pateen
        Icon for Helper I rankHelper I
        7 years ago

        I wanted to clear up my terminology here and bit clearer in my problem
        I now have visibility in PBI desktop to our base SharePoint website listed below.
        I do this by navigating to -> get data ->SharePoint Folder and connecting to the following link.

         

        https://mycompany.sharepoint.com/sites/GlobalDataRepository

         

        However, data appears in here as source data rather than allowing me to navigate further.
        This maybe because I picked “SharePoint Folder” option above
        I need to go to a library called DataStore as per the link below

         

        https://mycompany.sharepoint.com/sites/GlobalDataRepository/DataStore

         

        In PBI web services, it is possible to navigate there by going to Create -> Data Sets -> Create New Content -> Files -> SharePoint Team sites -> entering the first link above.


        I’ve tried getting data as a Text/CSV in PBI desktop by inserting the web address in the windows folder address bar but the error message returned says “Windows cannot find … Check Spelling”
        I’m really doubt this cannot be this complicated but any help on this please …..