Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
TingLi
New Member

Power BI Report Builder- Query Designer not showing all features

Hi, 

I'm new to Power BI, I'm trying to create/map the parameter in PBI Report Builder Qry Designer. I do not see many option/features as same as in the snippet attached which was taken from youtube. I'm using the latest version. 

 

How to get the same screen with all features. I need to pass a parameter to allow users to change the date. The query is throwing error when I pass the parameter name instead of date in the below condition 

 

condition => date = cast('text',formatdate('MM/dd/yyyy',To_Date('MM/dd/yyyy' , '08/01/2024')))

 

 i tried with the different options as below, nothing is working 😞

@parametername

'@parametername'

'"&parametername&"'

 

Your help will be highly appreciated..

 

My screen

PBI_RB_Qry_Designer.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Expected Screen

Expected_PBI_RB_QryDsgnr.png

 

 

 

 

 

 

 

 

 

 

Thank You..

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @TingLi 

If you want to get the query designer of the window you are looking forward to, you need to connect to SQL Server, as shown in the following figure:

vjianpengmsft_0-1723003921957.png

vjianpengmsft_1-1723003939206.png

vjianpengmsft_2-1723003981225.png

vjianpengmsft_3-1723003991289.png

Each data source has its corresponding query designer.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi, @TingLi 

If you want to get the query designer of the window you are looking forward to, you need to connect to SQL Server, as shown in the following figure:

vjianpengmsft_0-1723003921957.png

vjianpengmsft_1-1723003939206.png

vjianpengmsft_2-1723003981225.png

vjianpengmsft_3-1723003991289.png

Each data source has its corresponding query designer.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Hi Jianpeng Li,

Thanks for your response. seems the feature is limited only with SQL Server! Could you please suggest how to pass the parameter in Query Designer, the options I tried didn't work. I need to pass this for a parameterized view for Denodo

@parametername

'@parametername'

'"&parametername&"'

 

Thank You...

Anonymous
Not applicable

Hi, @TingLi 

Thank you very much for your reply. As you described to, I tried to pass the parameter using my SQL Server query:

vjianpengmsft_0-1723014112995.png

SELECT *
FROM SampleData
WHERE ID = CAST(@ReportParameter1 AS INT)

vjianpengmsft_1-1723014219044.png

Your query formatting should be adjusted similarly to mine. You can test whether your data source supports passing this parameter using some simple columns, such as the ID column. And rewrite your query statement as I have written this.
Of course you can just re-edit your original query statement, but you need to check that the date of your parameter matches your database to make sure that the date of your parameter is in the database.

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.