Notifications
Clear all
Topic starter
Hi Team,
I am using SQL for data and did the relationship in power pivot. When I add the column (or) change the name of the column in SQL data base, I cannot refresh the power pivot model.
Can you please guide me the specific video regarding source data modification(new column (or) change the name of the column header) and how to refresh the model after source data modification.
Thank you.
Regards,
Aye
Posted : 10/11/2020 12:48 pm
Hi Aye,
You should be getting the data with Power Query and then loading it to Power Pivot from there. Then you can edit the query to fix the name of the column so it matches what it was called originally, or to include new columns.
Mynda
Posted : 10/11/2020 6:25 pm
Topic starter
Thanks, Mynda.
I will try with PQ then.
Regards,
Aye
Posted : 11/11/2020 7:04 am
