Forum Discussion
Power BI: Invalid column name error
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!
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.
1 Reply
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.