Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a number of reports that run from SQL Server tables that I maintain.
All my reports import the data and then they are synced through a gateway to online versions every night.
If I add a column to one of the source table then refresh the data in the desktop product, the refresh fails as the underlying data has changed.
Is there any way to get Power BI to see there is an additional column and add it to the available fields (maybe incremental refresh).
I'm not changing existing columns only adding new ones.
Thanks
Simon
Solved! Go to Solution.
I'm afraid power bi service will not add the new columns automatically, you need to open pbix and add the new column in query editor(advanced editor) and then publish to power bi service.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm afraid power bi service will not add the new columns automatically, you need to open pbix and add the new column in query editor(advanced editor) and then publish to power bi service.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Jimmy
I have sort of solved the problem as well.
I was dropping the table in SQL and recreating it with a create table statement.
I found that if I add the field using 'Alter Table' and then refresh in Power BI, its fine with it.
Thanks for the advice
Simon
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
92 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |