Data Refresh in Power BI Service is not bringing new columns

[Sunil_PBI]

I have added few more columns for the view in Snowflake. When I tried refreshing data model in Power BI service, newly added columns are not reflecting. However, if I download the file and refresh the data in query editor in power bi desktop, columns are coming up. Let me know if anyone have a quick fix for this issue.

[Shivansh]

I am also looking the automated way to achieve this.

[Anonymous]

Hi @Sunil_PBI 

Changes in data source table structure, or schema, such as a new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail. For more information, you can refer to the following document:

Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

[Sunil_PBI]

Hello Jayleny,

I have not modified existing columns, just added few more columns in the backend view. I have scheduled data refresh to happen once in a day and it's running fine. But it's not bringing newly added columns. I wanted to show those columns in text table in one of the dashboards. To do this, I need to download the file, run a manual refresh in desktop and push it back to service. It's very painful to follow the same process every time. Instead, I am looking to perform this task in the service. Let me know if you have any workaround.

[Anonymous · Accepted solution]

Hi @Sunil_PBI 

It is explained in the documentation above: new, renamed, or removed column can only be applied in Power BI Desktop, and in the Power BI service they can cause the refresh to fail. Although your refresh is running fine, your newly added columns will not be refreshed.

Best Regards,

Jayleny

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

[aj1973]

Hi @Sunil_PBI 

You first need to refresh the PBIX in your Power BI desktop and then publish it to the service.

[Sunil_PBI]

Why the refresh in power BI service is not bringing newly added columns in the source table, If I do the refresh in power bi desktop in query editor, it's showing new columns. Every time I cannot follow the same process as it's going to be a manual task. Is there any way to automate this in Power BI service?