Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

 

1 Reply


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