Maximum number of column only 100 ???

[my62002316]

Hi,  

   Just encounter one weird problem, if my table  has more than 100 columns, the PBI query will prompt me an error saying that "xxx column was not found". I need to remove all the columns after the 100th columns under "Change Type" to solve this error. What a funny problem. Please fix it.

[v-cazheng-msft]

Hi @my62002316 

Currently, there isn't an official document said maximum number of columns is 100. May I know are you using Import mode to connect to your data source? What kind of data source are you using? If you clear cache and promote the following metric, will these columns be identified correctly?

Best Regards,

Community Support Team _Caiyun

[my62002316]

Hi,

   I still receive the same result after clearing and promoting the cache. I have the error message even though the column is available in the table. This happen after the Change column name step.

[v-cazheng-msft]

Hi @my62002316 

Thanks for your reply. Could you please check your applied steps pane in your Power Query before you apply changes to see whether there is any warning or error?

Best Regards,

Community Support Team _Caiyun

[my62002316]

Hi,

   No error/warning can be seen.

Regards,

eeway