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.