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

[Anonymous]

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.

[Jimmy801]

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

[dax]

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]

 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 · Accepted solution]

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.

[Anonymous]

Hi,

     I cleared the corresponding permission in datasource setting in Edit Queries and reloaded the file through Web and i was able to load the data from SHare point. 

Thanks for your help.