Importing Data from Multiple Worksheets in SharePoint Online

[mgaughan]

I'm having issues importing a workbook from Sharepoint that has multiple tabs. When I load data through the query builder, Power BI recognizes the workbook, but does not recognize that there are individual worksheets that need to be uploaded. Does Power BI support uploading workbooks that have multiple tabs through SharePoint? Has anyone else encountered this issue?

[v-jiascu-msft]

Hi @mgaughan,

According to my test, it works fine. Could you please do some trouble shooting?

1. Does the workbook contain any models?

2. Did you connect Power BI Desktop to SharePoint?

3. Did Power BI recognize even one worksheet?

There are some limitations of importing a workbook, please reference: powerbi-desktop-import-excel-workbooks and powerbi-desktop-use-onedrive-business-links.

Best Regards!

Dale