Forum Discussion
Duplicated data with underscores when loading excel file in Power BI Desktop - Which one to choose
Hi Anonymous
Just as rajendraongole1 post that the underlined part is the standard table that exists in your .xlsx file, and the part without the underscore is the part of the table that Power BI automatically recognizes, which may not be very accurate sometimes.
Here are some ways of creating tables in Excel as a supplement:
Create a table in Excel - Microsoft Support
7 Ways to Make a Table in Microsoft Excel | How To Excel
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous
No, this has nothing to do with the accuracy of the data itself, it only affects the scope of Power BI recognition.
Here's a sample for your reference:
I have 2 tables in the .xlsx file:
when I didn't format them as tables, the power bi could recognize the two tables as one:
But we can select the data and format it as table separately:
Then Power bi can recognize correctly:
Misidentification is still preserved:
Whether it is underlined or not, you can use it as long as the range of cells it selects is correct.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for your answers rajendraongole1 Anonymous! But I am a bit confused. Anonymous said the part with the underscore is the original data in the .xlsx file as rajendraongole1 posted. But I think what rajendraongole1 posted said that the non-underscored part is the original data? Did I get you wrong here?
Hi Anonymous
What I mean by this is that the underlined part is the data in the form of a table (you've formatted it as table in Excel), and the one that doesn't have an underscore is that your Power BI automatically divides the data in the .xlsx file that might be a table, which is automatically generated, so the non-underscored part is the original data.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Anonymous . It means that if there are two versions for the same table, it's better to use the non-underscored one as the underscored one by Power BI itself sometimes may not be very accurately. Is my understanding correct?
Hi Anonymous
No, this has nothing to do with the accuracy of the data itself, it only affects the scope of Power BI recognition.
Here's a sample for your reference:
I have 2 tables in the .xlsx file:
when I didn't format them as tables, the power bi could recognize the two tables as one:
But we can select the data and format it as table separately:
Then Power bi can recognize correctly:
Misidentification is still preserved:
Whether it is underlined or not, you can use it as long as the range of cells it selects is correct.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Got it. Thanks for the detailed explanation!