I like the way you have created M-Query Parameter. I found it to be a clever and effective solution. Well done! Thank You!. I am eagerly looking forward to watching another new video!.
I'm working on a project at work to build a self service portal for end users, and I need end users to be able to input a parameter which would then be used by DirectQuery to fetch data from oracle db. Exactly what i needed. Great video. Thank you!!!
This is all great. But, what if I need to use multiple parameters that have to be filtering out each other on the interface, not in the filtering pane. I need basically 4 parameters - Plant - Production Area - Business Area - Line Name, to work as injectable parameters and also to filter out each other. Is this possible? I'm looking for an answer to this question for 3 months now. Thank you for your work!
Great video! I was hoping to reproduce it to a T but my system tells me that direct query doesn't support the usage of the parameter (at the step where you work in the advanced editor to input the parameter). It forces me to switch back to import modus, where I can't link the parameter. Not sure what the problem is :/
How can I pass the value in mysql query dynamically from the report section whatever user selected in filter 1) users select a single date that date should pass on my store procedure which I am calling in power bi while fetching the data from database How can I achieve this please help..
I got a scenario where I have a stored procedure from SQL server where I'm passing two dates as inputs. When I create parameters its working fine. But I would to have my end customer to have those two dates listed on the Report and which dynamically can get passed to the stored procedure. I'm quite new to Power Bi and verified various material to handle such scenario but no luck. Any leads on this scenario.
Do we have any functionality where we can redirect a visual to a particular module in an angular website post integration of a report in the same angular website?
Great Video! But I am stuck somewhere if anyone could help me I have created the dynamic m query parameter for routeno and binded to routeno present in my routehistory table but in slicer I want to use the route name column present in my routehistory table like changing any route name in slicer also change and update M query routeno parameter value
Can you help if we can pass multiple list.contains parameter in table.selectrows ? Use case to filter query with multiple slicer which are multi select , already storing them as list .. any help would be great .
Hi, I tried this for date time parameter and it works with dropdown or a list slicer. Could you please suggest how to use this with date picker slicer and data type parameters.
I am using direct query mode. I see bind to parameter, but parameter isn't coming. I am only seeing None. The example you shared, the data source is SQL Server. Does it work with Oracle SQL datasource? Thanks
Thanks, I'm able to do this. How to apply this for multi select on a Category (Eg: Stores)? and mine is a direct query. Is this possible on a direct query?
Yes, it's possible to use dynamic M query parameters for multi-select on a category like Stores in Power BI, even with DirectQuery. You need to: Create parameters in Power Query. Bind these parameters to a slicer. Ensure the M query in Advanced Editor references these parameters.
@@ajlfit Thanks for the feedback. However, I request you to watch the video again. Table is in Direct Query only. However, when I create a separate table from a Blank Query, that becomes the import one.
Your dataset should be DQ Query mode only. For more prerequisites, please visit: learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters/?wt.mc_id=MVP_356016