Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Import multiple files(Excel and CSV) from sharepoint to power bi desktop?

How to Import multiple files(Excel and CSV) from sharepoint to power bi desktop? I don't want to combine the files. I just want to import one Excel file (3 tabs) and one csv file from sharepoint.

Excel file contains: tab1 - product, Tab2 - Geo, Tab3 - Manufacturer

Please provide a detailed steps.

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi arunkumara, 

    You said connect from dataflow? or sharepoint by web connector? You could clear the corresponding permission in datasource setting in Edit Queries, then try my above suggestions to connect sharepoint by web, then pass the credential of organizational account to see whether it work or not. If you want to connect to  pbi dataflow, you use pbi dataflows connector directly and pass the organizational account.

     

    Best Regards,
    Zoe Zhi

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

5 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi arunkumara, 

    It seems that you want load sheet in Excel seperately, right? If so, you could try to use Web connector. You could get folder path like below(open file in app, the copy the path from Excel, and remove ?web=1 in path), then it should work

     Then you could load the cvs file. They won't combine and will show seperately.

    Best Regards,
    Zoe Zhi

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       Hi,

       

            Thanks for your reply, Can you please provide the steps for the web connection through Dataflow for the xlsx? 

             Am unable to connect, getting an error stating that "Invalid Credentials"

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi arunkumara, 

        You said connect from dataflow? or sharepoint by web connector? You could clear the corresponding permission in datasource setting in Edit Queries, then try my above suggestions to connect sharepoint by web, then pass the credential of organizational account to see whether it work or not. If you want to connect to  pbi dataflow, you use pbi dataflows connector directly and pass the organizational account.

         

        Best Regards,
        Zoe Zhi

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

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello Anonymous 

     

    use this syntax to read from Sharepoint for Excel-files

     

    Excel.Workbook(Web.Contents(FileName))

     

    and this one to get CSV or TXT-file

     

    Csv.Document(Web.Contents(FileName))

     

     

    If this post helps or solves your problem, please mark it as solution.
    Kudos are nice to - thanks
    Have fun

    Jimmy