Query Undefined

Anonymous · ‎01-28-2020

Hello All

I have a report that has multiple score cards and the report is populated froma SQL Query. When i added a new column all the score cards were replaced with an "X" When i clicked on each field in the data pane it says "Query [undefined]" , can someone please advice?

Thanks

VasTg · ‎01-28-2020

@Anonymous

What was the error you got in Query editor/Transform data?

Do you have the correct username/password?

If this helps, mark it as a solution

Kudos are nice too

Connect on LinkedIn

Anonymous · ‎01-28-2020

No error in the query , it shows the data . The error is in the report and it says "query [undefined]" is there an easy way to upload image? God they make everything less easier .

Added to my woes i deleted on of the score card and added a new card and added the field and the filter doesnt work (the drop down to select basic filtering)

VasTg · ‎01-28-2020

@Anonymous

Do you have the visuals in the pbix where you connect to source or does your pbix connect to a service dataset? If so, did you rename any of the columns?

Refer to this on how to post screenshot..

https://community.powerbi.com/t5/Desktop/Post-screenshot-to-this-forum/m-p/911210

Connect on LinkedIn

Anonymous · ‎01-28-2020

Thanks none of the columns are images, its just 8 columns all data type money except one which is a varchar and the report was running good, i just added a NEW COLUMN (NOT RENAME).