Help - I don't can load files with the first header with * as first character

[Anonymous]

Hi all!

I tried load data from excel workbook, the first row is combine in different groups of data, the second has the headers.

But when I load the book...

But if I erase "*".... Works!!

How can solved on Power BI?... I need combine a lot of files....

Thanks!

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ;

I tested it, if * is the first character, my side is working normally, maybe you can update the power bi version, my version isVersion: 2.104.941.0 64-bit(2022-04)

Or can you share your file?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi Yalanwu,

Thanks for you review, I tried and Works. So the original file is the problem.

How can send you the file?

Thanks.

Regards,

[Anonymous]

Try #"*HeaderName"

--Nate