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?
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.
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.