Service

[Brausmith]

Through the web app I'm Importing an Excel file from Sharepoint so that I can create a Dashboard.

But, after doing so it is missing a lot of Tables from the file.

Funny thing is that I can Connect the same file as a Workbook under Reports, and all the data is there.

I'm lost as to why my dataset import is missing so much data?

[v-sihou-msft]

@Brausmith

Is there any changes in that Excel file after you import it?

Power BI connect the Excel files on Onedrive/Sharepoint hourly to sychronize the data automatically. Please do manually refresh to see if you can view all datasets in that file.

Reference:
Get data from Excel workbook files
Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

Regards,

[Brausmith]

I originally had the excel file imported perfectly and it was updating. Then it stopped.

So I removed the file and reimported it. This is when it wasn't working correctly with missing tables of data.

I've removed and reimported it a number of times now with no change.

I'm now completely stuck.