Is there any way we can send enum value for the string parameter. Say I have table Country having 2 columns Country and Country ISO Code. In Parameter I pass Country and the corresponding Country ISO Code should be passed as parameter to a stored procedure in sql. This is to dynamically run the stored procedure based on the parameters
How come when I try to create new parameter in manage parameters, it wont let me drop down on the Query box to select a query? This is show at 6:15 in vid. Thanks, always appreciate there helpful vids
is it possible to pass a slicer selection as a input value to a function or procedure that we access from datasource? i have a requirement where i need to access a function from a database in power bi. Please suggest
That's a great video..Is there a way that this can be used in publised dashboard. Like user can enter the value in dashboard and visual should change accordingly. Kindly help..!
We give the App to end user and they should be able to change the parameters. May I know how to change the parameters in service account within the App?
Great instruction, Mohammed! In my case I need the query to return results using not one region (Europe, for example), but return results for a large list (over 3000) of regions. Is this possible?
Hello taik18 i have a problem with the parameters, i will like to pute the value in a filter for example(date value) so the user can check the date that he wants. Is possible that?
@@taik18 can you help me with that? I have a store with a parameter but i need to call that parameter from other query, for example exec proc_Test where Date = @date Then i call that parameter from other querie that contains only dates so when i modify that date from the other query the Store will be refreshed. that date paramater will be in a filter for example, i tried everything...can you help me? I have Pro license.-
This way is not possible in Power BI service, in desktop it is possible.. U can use direct query to get only required data.. Or import with filter. For this u need view not stored procedure
Could you please explain on how to add a parameter that is from a list which is again obtained from querying country table in our database. Receiving the error "Formula.Firewall: Query 'ER Transactions' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
@@taik18 Thank you for the link, but its different requirement. I have table COUNTRY in BI which is having country details, Country, Currency, Companies (queried from sql server table Country). I need to use this Country List & Company List as dynamic parameters for sql stored procedure to get the transactions per country, company based on the parameters I have entered.
Yes you can , in this video I have shown about single parameter which is dynamic based on user selection. Still not clear pls email me.. mohammedadnant@gmail.com
1 question on Power BI: how to get around privacy setting when referencing a parameter into a SQL query. - I have 2 text parameters: PositionTitle1 and PositionTitle2 - I have a SQL stored procedure asking for 2 inputs: PositionTitle1 and PositionTitle2 - I need to run that Stored Procedure on my SQL database and get the result into data table in Power BI. Please note that Ignoring Privacy Level is not an option. I need to find out how to do it with standard setting because I need to provide my solution to a wide range of users. You can either send me a clear instruction or do it live with me (preferred). I need it soon. Thanks.
![How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]](http://i.ytimg.com/vi/WgE8pVLgWGs/mqdefault.jpg)
Is there any way we can send enum value for the string parameter. Say I have table Country having 2 columns Country and Country ISO Code. In Parameter I pass Country and the corresponding Country ISO Code should be passed as parameter to a stored procedure in sql. This is to dynamically run the stored procedure based on the parameters
Yes you can.. using '"&value here&"' , email me if u need clarity.. mohammedadnant@gmail.com
Thank you very much, it helped me a lot for my work
=)
Glad you liked it... Thanks for your feedback...
so touching for an excellent video
Thank you so much for your feedback 🙂
This is really great information. Thanks man
Glad you liked it
Thank you very much!
You are welcome
Character In the video It's great, I like it a lot $$
How come when I try to create new parameter in manage parameters, it wont let me drop down on the Query box to select a query?
This is show at 6:15 in vid.
Thanks, always appreciate there helpful vids
Even, i too faced this issue... please assist taik
here the parameter used is varchar, but i need to enter an integer... how code in advanced editor will get changed... pls reply
logically Integer can pass as string, string cannot pass as integer, pls try the same way, it should work.
is it possible to pass a slicer selection as a input value to a function or procedure that we access from datasource? i have a requirement where i need to access a function from a database in power bi. Please suggest
Hope this video will help
th-cam.com/video/1YivcVUXTG0/w-d-xo.html
That's a great video..Is there a way that this can be used in publised dashboard. Like user can enter the value in dashboard and visual should change accordingly. Kindly help..!
Thank you... So far we don't have this option in Power BI service..
We give the App to end user and they should be able to change the parameters. May I know how to change the parameters in service account within the App?
SQL stored procedure parameter change is not supported in power BI service..
@@taik18 Thank you!
its a great video, ,
how can I fetch date from a date slicer as the Parameter??
please suggest.
can this parameters be updated from power bi service?
Not support so far..
Great instruction, Mohammed! In my case I need the query to return results using not one region (Europe, for example), but return results for a large list (over 3000) of regions. Is this possible?
thats a big number, you can filter it in the source itself.
Hello taik18 i have a problem with the parameters, i will like to pute the value in a filter for example(date value) so the user can check the date that he wants.
Is possible that?
Yes possible
@@taik18 can you help me with that?
I have a store with a parameter but i need to call that parameter from other query, for example
exec proc_Test where Date = @date
Then i call that parameter from other querie that contains only dates so when i modify that date from the other query the Store will be refreshed.
that date paramater will be in a filter for example, i tried everything...can you help me?
I have Pro license.-
This way is not possible in Power BI service, in desktop it is possible..
U can use direct query to get only required data.. Or import with filter.
For this u need view not stored procedure
@@taik18 yes i did that, but when i put a different date in the other querie(the query with only dates) my main query(the Store) goes blank, :(
I didn't get that, can you pls write me an email.
Thanks so much. How do you add filters in the report so we can use this parameter?
unfortunately, parameters we cannot use in Power BI Service, which explained in the video
Could you please explain on how to add a parameter that is from a list which is again obtained from querying country table in our database.
Receiving the error "Formula.Firewall: Query 'ER Transactions' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."
Check this video might help.. if not pls email me..
th-cam.com/video/nyb8dC3rtNc/w-d-xo.html
@@taik18 Thank you for the link, but its different requirement.
I have table COUNTRY in BI which is having country details, Country, Currency, Companies (queried from sql server table Country).
I need to use this Country List & Company List as dynamic parameters for sql stored procedure to get the transactions per country, company based on the parameters I have entered.
Unfortunately till now
SQL stored procedure parameter is not available on power BI service online...
@@taik18 I was referring with PowerBI desktop only
Yes you can , in this video I have shown about single parameter which is dynamic based on user selection. Still not clear pls email me.. mohammedadnant@gmail.com
1 question on Power BI: how to get around privacy setting when referencing a parameter into a SQL query. - I have 2 text parameters: PositionTitle1 and PositionTitle2 - I have a SQL stored procedure asking for 2 inputs: PositionTitle1 and PositionTitle2 - I need to run that Stored Procedure on my SQL database and get the result into data table in Power BI. Please note that Ignoring Privacy Level is not an option. I need to find out how to do it with standard setting because I need to provide my solution to a wide range of users. You can either send me a clear instruction or do it live with me (preferred). I need it soon. Thanks.
In order to run SQL stored procedure on SQL u need to run this on SQL agent. Pls write me email if required in detail
mohammedadnant@gmail.com
Hi...,Can u tell how to use Store procedure for "Direct Query" mode in Power BI.
thanks in advance 😊😊😊
Thanks for your query.. sure I will check and get back to you...🙂
How to pass date parameter in SQL query instead of store procedure
In SQL use where datecolumn between ' ' and ' '
@@taik18 Thanks for reply.
I'm fetching data using SQL query in Power query, for that I need pass date parameter. Similar like you're passing to SP
Indian... but good!
Thank you..
Hi.
I want to pass 3 parameters not only one ( from date,to date, country)
Can you make a video about it or reply me it will be well appreciated ♥️
Pls check in the comments.. if that doesn't work let me know.. thank you
@@taik18
I didn't see anything in the comments related to my question but i think the solution is to add (group as text, country as text ..etc)
Yes and in SQL query u have to add
'"& value here &"' , to add multiple parameter
@@taik18
Thanks you helped me a lot
It feels happy to hear this.. welcome..
This is hard coded.... Do u have any idea about not hardcoding
This is not hard coded.. it is dynamic.. but parameter we can't use in power BI service online..