Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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 Online
Regards,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.