Column Limit in Table Visual (using Field Parameters)

[biswastrisa23]

BUG? - We are using dynamic Field Parameters to show columns in a table visual in Power BI report. There is 200+ columns in the table. The maximum we have been able to show and export to excel from the table is 167 columns. Not sure how it is happening, or if there is a limitation on the number of columns, we can show in the visual using field parameters.

Didn't find anything on Microsoft Learn's pages.

[Anonymous]

Hi  @biswastrisa23 ,

What connection mode are you using? We saw you mention that this problem occurs when exporting to excel, please make sure there are no known limitations meet below 

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best regards.
Community Support Team_Caitlyn

[biswastrisa23]

I am using Power BI dataset source - live connection. My dataset file (model) is published in a premium workspace. I am using Import mode to import all data in the power bi dataset.

The problem is I am even not able to see all the columns in the table visual. I could see maximum 167 columns and therefore in export to excel also I got 167 columns. I do not see any limitations which applies to my scenario - in the link shared by you. There are limitations for Matrix which I am aware of, but for me it is a Table visual.

[tellquario]

Has there been any update on this issue? I have encountered a similar situation where I can only export 151 columns despite having 168 columns selected in my field parameter for a dynamic table visual.

[NamanMittal15]

Hi , 

I was under impression that there wouldnt be any column limitation..but when i wrote complete code, found out only 151 cols are appearing in the table .....in which i added 386 of total columns in the code.

Need this update asap.

[shahnawajk]

Hi @NamanMittal15 and @biswastrisa23, My question is, Where you able to create a field parameter with 200+ or 300+ columns? For one of the requirements I have, I don't need to display All the columns but a user should be able to select from a list of 300+ columns (in a Field parameter slicer) and show only 2 columns in the table. Will it work for me?