Query Undefined

[Anonymous]

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]

@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

[Anonymous]

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]

@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

[Anonymous]

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).

[VasTg]

@Anonymous 

Attach a mock up file to test it.

[Anonymous]

how to do that?