Forum Discussion
PowerBI Report Builder - using PowerBI Model connected to Redshift
I'm trying to use PowerBI Report Builder against a PowerBI BI Dataset Connection , where the PowerBI model is using Amazon Redshift as the datasource. I have tried following the instructions fo...
d_gosbell
Super User
Super User
Anonymous wrote:
the query that get generated is incorrect as there is no From Clause,
The query that you have posted is a DAX query. The DAX language does not have the concept of a "From" clause. I can't even think where you could insert one without it throwing a syntax error.
Did you make sure that the query editor in report builder was in DAX mode? The other mode it supports is MDX and that language does have a FROM clause, but you can't really mix and match DAX and MDX.
I think if you make sure the query editor is using DAX that the original query you posted should work fine.