- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Excel Dataset Import - Missing Tables
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-18-2017 07:55 PM
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?
Re: Excel Dataset Import - Missing Tables
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-20-2017 03:00 AM
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,
Re: Excel Dataset Import - Missing Tables
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-20-2017 03:15 PM
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.