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.
Hi,
When I use PowerBI connect to sharepoint excel file, and load the excel data to powerBI, I found there are many unknown data. The source file actual records are 4000, however, PowerBI get 24000 records, why?
Excel has workbooks with sheets. Sheets can contain tables and ranges. Oftentimes users work with an excel file for a long time, making many edits, additions deletions, moves etc. It is possible to have a range defined with 24000 rows, but only 4000 of them actually contain data.
You can either clean up your excel file (copy/paste your data to a new file) or you can use Power Query to remove blank rows.
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.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |