Forum Discussion
Solved
Common Table Expressions using WITH
hello all, I am attempting to use a Common Table Expression to query multiple tables in one query and output one table combining them. I can run this query using other SQL programs to query the ...
I was able to fix it. PBI did not like the query without a fully qualified reference to the table with schema.table reference. I did not know that limitation.
What error message are you getting?
Can you put this CTE expression in a view and then just reference that view from PowerBI?
I was able to fix it. PBI did not like the query without a fully qualified reference to the table with schema.table reference. I did not know that limitation.
hp2328 wrote:I was able to fix it. PBI did not like the query without a fully qualified reference to the table with schema.table reference. I did not know that limitation.
It might depend on what your default schema is or what connection options Power BI is using. I'm glad your found a solution.