Forum Discussion

TingLi's avatar
TingLi
New Member
2 years ago
Solved

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...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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:

    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.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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:

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.

 

 

 

 

TingLi's avatar
TingLi
New Member
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, TingLi 

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

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

    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.