cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KReynolds
Frequent Visitor

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.

KReynolds_1-1635860988270.png

But, most relevant searchers for help on the internet show this window appears after the "Query Designer" button is clicked, that seems to be using SQL.

KReynolds_0-1635860924522.png

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @KReynolds 

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
garythomannCoGC
Super User
Super User

Query Designer is a bug and should be removed/commented out 

Vote to have QD removed from the m$ code base.

GilbertQ
Super User
Super User

Hi @KReynolds 

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors