Question on Source as Excel files using Power BI with SharePoint Folder

[DineshSingh]

Hi All,

I am currently using Power BI for one of Project and client would like to have source as excel files on SharePoint folder.

• I can connect SharePoint folder and able to access all the excel files sitting on SharePoint folder.
• When I tried to combined all the files in Power BI, I get an error.

STEP 1 – I chose “SharePoint Folder

STEP 2 – I provided folder path of “SharePoint Folder

STEP 3.  I selected all the excel files from SharePoint to Power BI and Edit

STEP 5.  I Removed all the Other Columns (Metadata) except Content

STEP 6. I Tried with One Click Combined

STEP 7.  Apply

STEP 8. I selected Sample File parameters and said OK

STEP 9.  I am getting below error after Processing Queries.

Regards,

Dinesh

[SaritaSenapati]

Hi @DineshSingh,

You may want to look into this https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/.

Let me know if this solves the issue you are facing.

Regards,

Sarita