This table is empty when get data from sharepoint

Make sure the account you're connecting in Power BI with has access to both the root of the site and those files. If you're using a different account, or if you only have access to the folder but not the base site, that could explain it (the SP connectors connect to a feed at the base site and then filters down on your criteria). 

Hi, Anonymous 

The error message "DataFormat.Error: There were more columns in the result than expected" indicates that the data structure in SharePoint may have changed, causing a query mismatch.
Check that there are no changes to the columns in your SharePoint list or library. If you add a new column or remove an existing one, update Power Query to match the current structure. In Power Query Editor, review the steps for the app. Look for any steps that might expect a specific number of columns and adjust accordingly. You may need to modify the Table.ExpandTableColumn step to include or exclude the required columns.
If you have unwanted columns in your SharePoint data, consider removing them from your query to simplify the data import process.
Also check that there are no duplicate column names in your SharePoint data, as this can lead to confusion in your query.
You'll also need to verify that you have the necessary permissions to access all the data in the SharePoint folder. Sometimes, permission issues can lead to incomplete data retrieval.

You can learn more from the following link:

Power BI How to Fix There Were More Columns in the Result Than Expected - Zebra BI

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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