Reply
Frequent Visitor
Posts: 2
Registered: ‎03-18-2017

Excel Dataset Import - Missing Tables

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?

Moderator
Posts: 1,361
Registered: ‎03-06-2016

Re: Excel Dataset Import - Missing Tables

@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,

Frequent Visitor
Posts: 2
Registered: ‎03-18-2017

Re: Excel Dataset Import - Missing Tables

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.