Forum

Notifications
Clear all

Adding new columns in source data for Power Bi

2 Posts
2 Users
0 Reactions
343 Views
(@pat)
Posts: 23
Eminent Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: