importing tables from excel online

[Anonymous]

I have five tables in a Sharepoint Library Excel file.

I created a dataset by importing a file, choosing the sharepoint library and the Excel online file.

I created a report from the new dataset and can see two of the five tables in the fields section when editing the report.

However three of the five tables do not appear here.

I have made sure all tables have no spaces in their table names, and that tables contain only data with no rows for totals or any other calculations.

How Do I add the other tables from sharepoint online into the dataset and report?

[Anonymous]

I was able to find the solution here:

https://community.powerbi.com/t5/Service/Import-Excel-With-Multiple-Tables-Only-One-Table-Imported/m...

There was a data connection in the excel file to some tables blocking the import of the tables into Power BI.

Connections were removed and the Power BI dataset was recreated.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Glad you have resolved the problem. Please accept your answer as a solution. People who have the same requirement will find the solution quickly and benefit from the thread.