Dynamically add all columns on the power bi report

[Bhavana_k]

I have a table, where every month a new column gets added in the table with values. Now, when I refresh the table manually or by XMLA end point the column comes into the data model. But I want that column to get added in the report(visual) as well.

I'm showing all the columns from that table into the report(visual) in the form of "Table Visual". How do I get this newly added coulmn into my Visual dynalically?

Alos, other than XMLA end point is there other way to refresh my single table?

Thanks,
Bhavana

[v-yueyunzh-msft · Accepted solution]

Hi,  @Bhavana_k 

According to  your description, you want to automatically display new columns in table visual after refreshing the schema with the XMLA endpoint. Right?

Visuals don't automatically recognize schema changes, and if you want to modify the columns shown in the visual, you need to add them in the "Editing" view mode of the report corresponding to the Power BI service.

In addition to using the XMLA endpoint to refresh the schema of datasets, you can also use other tools,like ALM Toolkit.

The more tools you want use to connect the dataset ,you can refer to this document:

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Bhavana_k]

Can you please expalin what do you mean by editing mode? Thanks.

[v-yueyunzh-msft]

Hi, @Bhavana_k 

When you refresh the schema of the dataset and you want to add new columns to the visual, you need to click "Edit" in the Power BI Serivice report.

Then you can put the new field in the visual you need . This is the editing view .

You can refer to this document:

service-interact-with-a-report-in-editing-view 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly