Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Report Builder Query Designer

I'm working in Power BI Report Builder version 15.6.1532.5 Please help me understand why when I hit the "Query Designer" button in Dataset Properties, this window pops up and requires DAX. Bu...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi Anonymous 

     

    This is because when using Paginated reports it is connecting to the Tabular Model which has a query language called DAX.

     

    Previous versions of SQL Server Reporting Services connected to SQL Server and used the query language of TSQL.

     

    You can drag and drop the columns into the Query builder and it will automatically create the DAX for you.