Forum Discussion
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?
2 Replies
- v-sihou-msftMicrosoft Employee
Anonymous
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 OnlineRegards,
- AnonymousNot applicable
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.