Power BI: Invalid column name error

[quibtisa]

I'm having trouble with my Power BI code and I'm hoping someone can help me out. I'm getting an "invalid column name" error when I try to run the following code:

SELECT * FROM [MyTable] WHERE [Column1] = 'abc'

I'm not sure what's causing this error and any guidance would be greatly appreciated. Thank you!

[v-xinruzhu-msft · Accepted solution]

Hi @quibtisa 

Did you use this code by importing data from sql, it seems a SQL query, the sql query can be used when importing date from SQL 

In power BI, you need to use dax, and please confirm that the column is existing in your table.

e.g Filter('My Table', [Column1]='abc')

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.