Forum Discussion
Synchronize new table columns in Power BI
I have a dashboard in Power BI Desktop with preloaded data from a SQL Server table with 2 columns (code and name) and it is published to Power BI Services. A column (last name) was added to this SQL Server table. The problem is that I do not have access to the source from Power BI Desktop, and in my matrix I want to add this new column but I should only work with the preloaded fields from Power BI Desktop and publish it; is it possible to do this and that when publishing it is synchronized and all the fields are seen in Power BI and How?
Hi luisgue ,
Add a new column designed to the schema refresh, which will show any data source table structure changes since the last refresh. In Power BI Desktop, schema refreshes are not available independently of other refresh types, and schema refreshes are not available in power bi service.
If the data in the new column can be derived or calculated from an existing column, consider creating a calculated column in Power BI Desktop. This method allows you to add new data to the model without having to access the source directly.
More information on data refresh can be found in the documentation: Data refresh in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi luisgue ,
Add a new column designed to the schema refresh, which will show any data source table structure changes since the last refresh. In Power BI Desktop, schema refreshes are not available independently of other refresh types, and schema refreshes are not available in power bi service.
If the data in the new column can be derived or calculated from an existing column, consider creating a calculated column in Power BI Desktop. This method allows you to add new data to the model without having to access the source directly.
More information on data refresh can be found in the documentation: Data refresh in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.