Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
343
Views
Topic starter
Hi,
I have an excel which is the source data of my PBI dashboard. I added additional columns in the excel but upon refreshing it resulted to error informing that the newly added columns were not recognized.
Per YT it says to go to View > Advance Query settings and then manually edit the number of columns indicated in there including the ones you are adding. Where can I find this Advance Query settings?
Thanks for your help
Posted : 22/06/2022 1:50 am
Open the query editor in Power BI (Home tab > Transform Data). Then on the Home tab > Advanced Editor.
Posted : 22/06/2022 6:51 pm