PowerBI Report Builder - using PowerBI Model connected to Redshift

[Anonymous]

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 found here to set up the report in Report Builder,"docs.microsoft.com/en-us/power-bi/report-builder-shared-datasets#what-you-need" 

I successfully create the PowerBI  model and created the query and copied it into Report Builder , the query that get generated is incorrect as there is no From Clause, 

// DAX Query

EVALUATE

  TOPN(

    501,

    SUMMARIZE(

      'CAPA_Master',

      'CAPA_Master'[Capa_Number],

      'CAPA_Master'[Capa_Description],

      'CAPA_Master'[Capa_Title],

      'CAPA_Master'[Capa_Scope]

    ),

    'CAPA_Master'[Capa_Number],

    1,

    'CAPA_Master'[Capa_Description],

    1,

    'CAPA_Master'[Capa_Title],

    1,

    'CAPA_Master'[Capa_Scope],

    1

  )

ORDER BY

  'CAPA_Master'[Capa_Number],

  'CAPA_Master'[Capa_Description],

  'CAPA_Master'[Capa_Title],

  'CAPA_Master'[Capa_Scope]

 I added the from Clause   "From Model"  which now gives the following error ,which leads me to believe that I can't use Amazon Redsift as the underlying data source .  

{"error":{"code":"DMTS_DatasourceHasNoCredentialError","pbi.error":{"code":"DMTS_DatasourceHasNoCredentialError","details":[{"code":"Url","detail":{"type":1,"value":"AmazonRedshift"}},{"code":"ConnectionType","detail":{"type":0,"value":"Extension"}}],"exceptionCulprit":1}}} (Microsoft Analysis Services)

Any help would be appreciated

[d_gosbell]

---

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