April 25, 2022
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