Dynamic Power BI reports using Parameters

How can we pass the parameter and click the REFRESH BUTTON ON THE POWER BI SERVICE REPORT?

This was awesome, and I was able to pass two parameters in the same table. Thank you!

what if we are on a webpage (pbi embedded - direct query) and i'm a teacher and we all (teachers) have their student ids and this id is in the link of the webpage and i want to display studentA and another teacher want to display studentB on the same report at the same time, is this possible ? @guyinacube

Hello, I want to pass user logged in through parameter to snowflake query. Please provide inputs how to implement this scenario. Thanks in advance!

can you suggest a solution How can I use the same parameter in Python script and refresh the data?

Wonderful. Instead of parameter values from Excel source, can we have the value passed from URL? Once submitted, the filtered data set must be returned from database itself?

Thanks for this great video!
Would be nice if we could pass parameters via variable in the power bi report link

Tu video esta increible gracias!!!! ahora perdona mi pregunta, yo necesito hacer una lista desplegable y seleccionar un parametro de alli, podrian ayudarme con alguna documentación o curso o asesoria, gracias.!

Hey Cubesters, Its Super cool.i have a question here.i want to make it as a filter ,intead of gng and refresh the things then how it work

Amazing!!

Great Video
Is there a way to use your report with parameters, but passing values directly in the URL?

cant this be done by using the excel in a join?

How do you pass parameter value from another web page for this situation when calling proc

I have a fact table with start_year (2020) and end_year(2023) parameters in it to limit the number of years worth of data. On top of this I have incremental refresh of last 13 months. I publish this file to web service and change the start_year parameter say from 2020 to 2019. Why does the parameter changes in web service doesn't take into effect? If I change from 2020 to 2021, it does make necessary changes but for the first time only after publishing the file. Any thought on this? My report should only hold only last 5 years of data with last 13 months of incremental refresh.

A little off topic, but how do you have your power query in darkmode?

How can we run stored procedure in Direct Query mode !!??

Hi,

I am getting data from an API that has two parameters like below in the URL:

Param1930=2021-01-01&Param1931=2030-12-31&format=JSON

These are the start and end dates of the report that I have manully set up in the API URL. But, how do I make it dynamic so that eveyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below:

let
Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

Damn will smith🎉

Great video. Great idea

Sir ,
Please help me to load data using Sql procedure

let
Source = Sql.Database(".,2014", "demodb", [Query="EXEC SPM_CUSTOMER_LIST "&Locationid & fromDate & Todate])
in
Source

Its Not working how can we pass multiple
Like SSRS
Date selection as parameter ?

Hi! So I am using a Windows 11 Enterprise, where can I find a SQL server?

Why it is not possible to select parameter directly from pbi page through end-user(customer) interactions with visuals(precalculation is expected to be avoided)? I mean invoking sp call calculation by filter or slicer(not parameter field in menu)

Finally.. a clear usage of parameter and function.

Exactly what I needed. Thanks for growing my knowledge with a smile!

Legend, this revolves some of the issues with not being able to use dynamic M parameters / slicer input with queries (in import mode)

as you can try to pre-fetch the data using the function and give the user the "slicer" experience too (in a Rest API scenario, where the API is very restrictive in terms of data slice)

I'm a bit confused. In your custom function, is it the StudentID Parameter that is called, or the StudentID query?

This is Awesome!!! 🤖

Woah, that was fine until it got to the 'here's one I made earlier' section, with the gateway set up. Gateway problems have been the bane of my life. I wouldn't want to mess with them. I think you should have explained that bit in more detail.

Hi Patrick, it was great explaination and solved my doubts too, but is there any way I can pass two parameters in the single function, and my parameters are coming from two different SQL tables.

Thanks

Hey Patrick, thank you for this lovely tutorial. Can you pls suggest me how to do the same with multiple parameter.
Please reply, stuck in the situation for few days

Is it possible to use plain SQL script instead of Stored Procedure?

how do i do that when using AnalysisServices.Database, not SQL.Database?

Unbelievable !!! Thank you very much, this is very much helping

Awesome!!! Can we think one step ahead? Let's say - I have columns for subjects, student admin. no. , and the email id. I want to send the personalized result to their email id. Any thoughts before I tear all my hair out? No Row level security please.

I enjoy the content, but I get confused when you make a practical joke by using the wrong method, please don't do that. it takes a lot to focus here. Thank you!

Like your video very much. How to use your method to have a date range as a parameter to pull the dataset, interact from the web? thx again!

Nice T-Shirt :) video is great too

Hey good job and kudos Patrick,

I do have a below challenge
1. I created a Dashboard which is connected with 10 different csv files which i kept in a folder.
2. On daily basis I need to dowload the csv file and upload in Power BI desktop
3. Daily I'm changeing the source file location, but file name doesn't change, only changing the sub-folder like "/11012021/", "/11022021/", etc.

4. How to make happen easier to take the latest sub-folder and the related csv files?

Can you do a in memory Excel or data source? Instead of having to go to the backend and update the Excel, can I do the same from the front end itself?

I've used like 10 of your videos to combine all of this magic into one solution. I've subscribed.
I have an API URL that shows a monthly agreement details for all of my clients. To get more details of what is covered under that agreement, I needed to enter in the agreement # into the API URL.
"finance/agreements/agreementID/whatscovered"

I want it so that the report has two tables, the agreements and when you select the agreement ID, the bottom table shows those details.
Basically, clicking the top table column ID will set a parameter and re-run a query.
I can't figure out how to do that, but this method allowed me to gather those details right now and create a table with them so that they can be referenced later.

💕🙏🙏🙏

Hi!
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.-

Hi Patrick, I embedded a PB report via Azure Portal function method. Is it possible I can pass the patameters into report via Embedded URL (token) in that case? Thank you very much!

thanks so much for the video Patrick ..Is there a way to export the PDFs from Power Bi service automatically or in less time? I need to get PDF report for each student in every class with the filter of each student is selected and they're hundreds .
Thank you.

Love it!

You are awesome man! I actually understood this first time through, unlike the 1 on 1 tutorial I had at work.

Could have just changed the SQL WHERE clause to use an IN()... then in parameters they just paste with commas between - no need to link to other stuff....
What I really want to know, is how to get it to create a sql query dynamically by changing table names, attributes and business date for the filter in slicers and retrieving the data in a matrix. I saw a guy do this with R... but he didn't retrieve different sets of data

Hi Patrick , can you show me how to use this in flat files from folder.

Say , I have 3 Excel sheets in a file and I have 3 such files in a folder in my OneDrive.

Each file in the folder is going to be a table in power bi.

I need to pull all these data from folder and do dynamic transition to b a table using parameters.

Iam helpless please make a video on this

please help ?

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)"