Forum Discussion
Analitika
Post Prodigy
Post ProdigyData table not match excelltable
Hello, I would like to ask why my data table differs from excel table? My report import excel file. Here is in data view in Power BI. Here is in excel:
Have you double checked to make sure that the excel data is in a table format? or all the rows are in a table format?
You can try the following:
Remove all formatting in the excel file by selecting all the rows and then Clear > Clear Formats under the Editing tab. The Power BI report now brings in all the rows.
Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.