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