Changing column

[AndrewD04]

Hi, 

So i have come to refresh my data this morning for a dashboard and found the number of columns has changed and i have spoken to who produces the data and they have said it will keep changing whihc keeps breaking my query, is there away for PowerBI when loading data to just take select number fo columns and ignore others.

[nvprasad]

Hi Andrew,

Yes we can do this in PowerQuery editor. Please keep in mind that whatever columns you have selected should be existing in the datasource with the samename. 

Thank You,

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad