Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
1.4k views
in Power BI by 27 29 37

I am trying to get data from an Excel file in Power BI Desktop, but I got this error "Model object names must be non-empty".

Power BI Model object names must be non-empty

Can you help me to know Why I got this error "Model object names must be non-empty" and how to solve it?


1 Answer

1 like 0 dislike
by 159 188 376
selected by
 
Best answer

Solving: Model object names must be non-empty

in Power BI, the "Model object names must be non-empty" occurs If one of the columns in your Excel file does NOT have a name, as shown below:

Power BI Model object names must be non-empty

So in this case, you just need to do the following:

  1. Open your Excel File.
  2. Review all columns headers and ensure that every column has a name.

See Also

by 27 29 37
0 0
Thanks Mohamed, it was the issue
If you don’t ask, the answer is always NO!
...