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.
I have done the refresh in the query editor.
Does anyone have any ideas?
Regards H-J-P
Solved! Go to Solution.
Hi Xiaoxin Sheng,
"You need to manually add these new fields in query steps formulas."
How exactly do I do that? Unfortunately, I'm not an expert yet. Thanks for the help.
Regards Heinz
HI @Anonymous,
Power query will cache previous table structure into query steps, these cached structures not auto changes based on your source fields. You need to manually add these new fields in query steps formulas.
Model doesn't update when SQL table changes
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng,
"You need to manually add these new fields in query steps formulas."
How exactly do I do that? Unfortunately, I'm not an expert yet. Thanks for the help.
Regards Heinz
I solved the problem using the Advanced Editor. Thanks Xiaoxin Sheng.
Regards Heinz
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 |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |