it´s not just that your solutions are great, the way your videos are presented is fantastic!
@GuyInACube
7 жыл бұрын
Thanks for the feedback David! much appreciated!
@srenjensen9235
7 жыл бұрын
To avoid the Native Query Edit permissions just go to the Security tab in Options and deselect 'Require user approval for new native database queries' - BAM.
@GuyInACube
7 жыл бұрын
woot! Thanks Soren!
@lenac3587
5 жыл бұрын
Wow, you're the man!! I had this problem and you solved it 👍
@ammarabbasi2438
4 жыл бұрын
No Such Option. Can you share screen shot
@squallehvonllauqs1811
4 жыл бұрын
@@GuyInACube BANANA...!!! ;)
@excelscientist5041
4 жыл бұрын
Unable to find this option
@pabeader1941
3 жыл бұрын
4 years later and you are still helping me!
@thebiccountant
7 жыл бұрын
Very nice vid! As you said, you can use for so many purposes: Fill in some URLs in your Excel workbook & you have a web-scraper: Create a query that takes a URL as a parameter and turn that into the function that you call instead.
@GuyInACube
7 жыл бұрын
So many possibilities :) Thanks for watching!
@lenac3587
5 жыл бұрын
Inadvertently stumbled upon how to remove prefix for column headers. Was wondering about that and had to remove them in M-code the slow painful way for a dozen queries. So happy to see how to resolve this here. Had to slowdown the speed, back up and pause many times to make sure I didn't miss anything. As a constructive feedback, it's kinda distracting and makes it hard to watch when the video switches rapidly snapping us out of the computer screen and watching Patrick's expressions explaining something although it makes it more interesting and less monotonous. It's like a sudden jolt, not complaining. Nevertheless learn a lot from this invaluable training which I have bookmarked for future reference.
@GuyInACube
5 жыл бұрын
Glad it was helpful for you Lena! Appreciate the feedback as well.
@joknt438
2 ай бұрын
You are a legend! Used the same principle on a web query to pass multiple stations to a string. Love it!
@PauloSilvaBarros
6 жыл бұрын
Nice video Patrick! It is not a solution to the problem what i'm searching, but takes me to a mind blown about how can i create good reports.
@GuyInACube
6 жыл бұрын
+Paulo Silva Barros awesome! Glad to hear 👊
@HMZ89
5 жыл бұрын
Patrick.......I just feel like giving you a hug. This was fantastic
@joshuaoha
6 жыл бұрын
Some of this is above my head but I'm learning a lot and enjoying your videos. Thanks man!
@GuyInACube
6 жыл бұрын
We all started somewhere! Keep learning the clicks! Thanks for watching.
@fangedmenace
5 жыл бұрын
Brilliant, this was the only comprehensible explanation of parameters I could find! Thank you!
@fredt3727
2 жыл бұрын
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)
@alejandrarodriguez3328
3 жыл бұрын
Great video! I did something like this importing the parameter excel table, and establishing a relationship with the main table that limits the report. Probably not the most efficient way as relationships add run time. Did not use parameters. What I like about this video is how it casually introduces ways to use parameters and custom functions. Thanks!
@romankultajev3660
2 жыл бұрын
Exactly what I needed. Thanks for growing my knowledge with a smile!
@albertjeremy3956
Жыл бұрын
Finally.. a clear usage of parameter and function.
@OzduSoleilDATA
7 жыл бұрын
I'm looking forward to seeing a video on parameters.
@GuyInACube
7 жыл бұрын
Will get one on the books.
@atteh204
6 жыл бұрын
Yeah, more vids on Paramters please. They seem very dynamic feature in Power BI. How to generally utilize them more?
@wynhopkins8438
7 жыл бұрын
Really good videos guys. Keep up the great work, this stuff is really useful for people. One suggested improvement would be to keep your student list in an Excel Table (Ctrl + t), to avoid accidents if someone inserts a row or column in that Excel file.
@GuyInACube
7 жыл бұрын
Great suggestion Wyn! Thanks!
@paul46722
3 жыл бұрын
Absolutely love your presentation style. Really informative content and very entertaining too. Cheers.
@malowalo
5 жыл бұрын
Great work Patrick! You’re very clear on your explanations and I enjoyed seeing your videos! You have a new subscriber...
@GuyInACube
5 жыл бұрын
Awesome!!! Thank you so much for the kind words and for watching 👊
@TheRehan110592
5 жыл бұрын
I wish all tutorial videos just like "guys in a cube". Thanks !!!
@renaudmontes7247
5 жыл бұрын
Loved the form and the function, thanks Patrick!
@vpin3515able
5 жыл бұрын
This is really Awesome Patrick. Kudos to your guys.
@rabsonlungu
5 жыл бұрын
Patrick, Awesome job! You're exceptional at it. Keep sharing.
@TheKZA
7 жыл бұрын
Great video, thanks. I've been wanting to know how to do this for ages.
@GuyInACube
7 жыл бұрын
Same here. Mind was blown :)
@myazigi
7 жыл бұрын
Patrick...you're awesome man!!! What a clever solution.
@GuyInACube
7 жыл бұрын
Thank you, Mauricio! And, thanks for watching.
@myazigi
7 жыл бұрын
Thanks to you Patrick, for take the time to teach us
@ramachandravarmamandapati7476
5 жыл бұрын
Great video on calling stored procedure from Power BI. Thank you very much.
@GuyInACube
5 жыл бұрын
Thanks for watching Ramachandra! 👊
@CoopmanGreg
5 жыл бұрын
Patrick! you should have your own comedy show. You are really funny. I think I like your comedy more than the content, but don't get me wrong the content is really good too.
@laurenlavallee9592
5 жыл бұрын
How can this be done when not using a stored procedure, just a regular query imported from SQL?
@kumarshourabh2627
6 жыл бұрын
I am working on a Facebook dashboard where I pass a parameter in the power query mode and this updates my tables and the corresponding charts get updated. However, I want a way to allow my end user to choose from a list of given values and accordingly the charts on the dashboard should get updated. Need help..!!
@netnitin
7 ай бұрын
Hi Patrick. The video was good. Can you also show how report columns can be dynamically filled as per dynamic query in parameter? say sometimes 5 column & sometimes 10 columns etc. depending on dynamic query. Thanks in advance.
@shreee1986
Жыл бұрын
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?
@mikehawryluk5558
7 жыл бұрын
Awesome video and clever simple solution!
@GuyInACube
7 жыл бұрын
Thanks Mike!
@estebandagobertogarciapere8457
6 жыл бұрын
Awesome Video!. Thanks. Could you pass those parameters from a textbox or dropdown button and call the storedprocedure from a button?
@justme1810
4 жыл бұрын
This was so helpful! Exactly what I was looking for
@Jakeu1701
7 жыл бұрын
Definitely has some interesting implications. I was just asked about something like this yesterday and wasn't even looking for this video. kinda spooky.
@GuyInACube
7 жыл бұрын
nice! We saw the future for you :) Thanks for watching Jason!
@tcaworf
5 жыл бұрын
Nicely done Patrick!
@GuyInACube
5 жыл бұрын
Appreciate that! Thanks for watching. 👊
@markusjager5608
3 жыл бұрын
Hi Patrick, Great video. How would you do the same report but instead of using a spreadsheet, let the user choose Students from a list on the report?
@danielperry1352
Жыл бұрын
Great Video Is there a way to use your report with parameters, but passing values directly in the URL?
@nilanjitroy3546
2 жыл бұрын
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
@merkstamde9115
7 жыл бұрын
Hey Cubesters, great video! I'm in awe of your creativity in coming up with solutions that automatize everything so neatly and concise. If I may, I have an issue of my own which I simply cannot find the solution to. I pass a custom query in advanced editor to a MYSQL server and would like to make it dynamic by passing a parameter inside the query. However, I'm unaware of how I'm supposed to that inside the ""WHERE"" part of the query. For example, I've created a parameter (LUNA) which resembles the month number and would like to pass it to my query in this section ** WHERE MONTH(data)
@pipriders
5 жыл бұрын
thanks for this amazing video man . its solved a same problem i was struggling from last couple of days api call with with hundreds of parameters
@soy34mb
5 жыл бұрын
Thank you. PATRICK, YOU ARE A GENIUS!!!
@amitshukla189
7 жыл бұрын
Hey @patrick you are super genius bro.
@GuyInACube
7 жыл бұрын
Thanks, Amit! And, thanks for watching.
@laurinkruesselberg7604
3 жыл бұрын
Great job, thanks for the input. I need to do the exact same thing with Snowflake, how could that be done?
@CetilLee
7 жыл бұрын
Very nice! Any chance of seeing what that stored procedure looks like?
@umeshyadavomi
4 жыл бұрын
Thanks Patrick, I can not refresh this dataset on PBI Service. Please help.
@uniQue_XL
7 жыл бұрын
wow...that's hot great out of the box solution. thanks !
@GuyInACube
7 жыл бұрын
Thanks! We thought so too!
@lumitic774
7 жыл бұрын
parameters are still a bit of a "mistery" to me. to "little" things I just connect the excel online sheet to the powerbi directly to the web version. Any excel online changes = power BI web changes, right? But i find this solution, very cool!
@angelikamariae
4 жыл бұрын
is all you did in this video possible while using direct query as well? I gave a try but I had some issues..
@successfullife7689
2 жыл бұрын
Unbelievable !!! Thank you very much, this is very much helping
@Rokkering1
6 жыл бұрын
Thanks for a great video! Is it possible to use this with DirectQuery or is this only supported by Import Mode? It would be awsome to use the functions and parameters to limit the number of rows returned from large datasets, making PowerBi an effective tool for big data!
@rayromych5534
Жыл бұрын
Thanks for this great video! Would be nice if we could pass parameters via variable in the power bi report link
@arpitvijay1024
2 жыл бұрын
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
@MoraesMM
6 жыл бұрын
Hello Patrick, great video thanks. This video makes me think of this scenario: Imagine a business expense report on PBI and add end users who would like to comment on this result using only the PBI site, I wonder if it is possible to combine this solution for this case: Maybe 1 some visual gets the comment on the page (will be my parameter), 2 identify the other parameters (filters on the page), 3 call the store procedure using this parameters and insert the comment in the database, 4 update the data set (I do not know how to do this for each entry) . I have not tried to do this, I'm just thinking of another applicability to this new knowledge I've received.
@luisaquino5556
6 жыл бұрын
Great video! You've helped me a lot. Quick question, if I am making a report that has model numbers and their related data, how could I go about making the report appear with no data until the user uses the filter function to show data for model numbers they choose to filter?
@sau002
4 жыл бұрын
Nicely explained. Can I place the Excel document in a shared location such as Azure blob storage or Sharepoint document library or some other better place you could recommend? Thank you
@mickaeltaieb733
5 жыл бұрын
Awesome content and engaging presentation. Thank you sir!
@gondebas
6 жыл бұрын
No. It is not dynamic way of pulling data from SQL database. It is rather step-like method. You cannot expect any mortal user to enter parameter that way. I could imagine that from small dimension table I select student name (or ID) by slicer or other visual and then after that the query is executed dynamically select * from FactTable where ID= SelectedParameter. That would be useful - the big FactTable would not have to be loaded in full but only chosen rows.
@anastasiiaillienko4750
Жыл бұрын
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)
@jyotisankarsahoo7937
6 жыл бұрын
Hi Patrick..Superb video.. I have a requirement in which I need your suggestion. I need to dynamically pass the parameters so that the report automatically filter out with respect to a ChatBOT prediction. Is it possible?
@venke75utube
4 жыл бұрын
Patrick....This one is amazing. One question I have after the dataset is refreshed my report more than a minute time to get refreshed with the new data.Why?
@Stelios.Posantzis
5 жыл бұрын
Great stuff! Nice presentation - very easy to follow : )
@vinayliesure
5 жыл бұрын
i have tried loading with sql table. it worked well, thank you. Good stuff
@MadhangiRam
2 жыл бұрын
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?
@jyaulhaque8593
3 жыл бұрын
Thanks for your video, is this possible to pass what-if parameter to power query editor , how
@nancychow7078
5 жыл бұрын
Awesome video, it solves a big part of my project request. On top of parameters, Patrick, my user wanted to supply a date to be inserted to the report as a new column, like something they do in excel. Is it doable in Power BI and if so, how would you do that?
@samtrexler106
7 жыл бұрын
Great video, thanks Patrick! I love your style, and I can imagine several uses for this technique. However, my main use case is not covered: Is it possible to modify the URL based on the selected row? For example, I have a visual that shows totals (measures) by Station. Can I pass the StationID in the URL so the detail report will show the rows related to the summary row the user clicked on?
@GuyInACube
7 жыл бұрын
It will all come down to DAX and what the filter context is. If you can get that StudentID, then you could use that to build out a URL in DAX. You would have to be filtered down to only that one student in that case though.
@praveenmanchukonda7911
5 жыл бұрын
I am new to Power BI and the video is very informative. In place of stored procedure call, can we use a t-sql query - a select statement?
@basciit
5 жыл бұрын
Yes, you can. Select ... where ColumnName = "&ParameterName]
@arezllee
5 жыл бұрын
Patrick, what if the source file for the parameters needs to be used by a large audience so that anyone at any time can jump in and do their dynamic filters? How would you approach this?
@easyguidetamil
3 жыл бұрын
I need to avoid run permission I had pass 16000different parameters can you helpon it
@lukasztrzebinski3217
6 жыл бұрын
Can you use parameters to define data source paths? Kind of like variable to help source data maintains?
@asheshshah2516
3 жыл бұрын
Guy in a Cube - Patrick i have tried using list query as a parameter but when i filter my data then followed by editing in advanced editor then my data shows blanks though there is data in the model for that parameter. How to fix now
@joelatino3748
3 жыл бұрын
This is so great. You guys are kings.
@visheshjjain
4 жыл бұрын
Hi Patrick! I am trying this approach in the service and the dataset configuration in the service is giving me the following error: "Query contains unsupported function. Function name: File.Contents" Can you please suggest a workaround or how to solve this? Thanks!
@danialsamar
7 жыл бұрын
Absolutely amazing. Thanks dude!
@GuyInACube
7 жыл бұрын
You're welcome!
@AnkitKumar90
5 жыл бұрын
Is it possible for end user to enter value in a text box and click the search button next to the box which will in turn return the data for that particular value in a table? For e.g. If the users type a StudentID in the text box and click the search button, it should return the data for that particular StudentID in a table. Thank you!
@loglife2
4 жыл бұрын
How about passing a parameter value from a URL into a Power BI Direct Query parameter from Power BI service? I watched the URL filter video, but the data can not be pre-loaded. Need to pass a URL parameter into a Power BI parameter, execute a direct query, and display the data in Power BI service. Is there a way to do this?
@gokulnathpl
2 жыл бұрын
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?
@muratvezir8350
4 жыл бұрын
This was made my day thank you very much
@GuyInACube
4 жыл бұрын
Always happy to hear that! Thanks for watching! 👊
@muratvezir8350
4 жыл бұрын
@@GuyInACube Dear Patrick. I have problem with this solution.If it's possible I would like to ask some questions with this solution.
@stevenrenton1808
3 жыл бұрын
Can you do something with 2 parameters like a start and end time of a list of events
@Mago_Legend
5 жыл бұрын
Excellent job man!!! It helped me so much. Thank you.
@GuyInACube
5 жыл бұрын
Awesome! Thanks for watching. Glad it helped.
@hippoborntolocalgirl
7 жыл бұрын
Lovely video, great feature!
@GuyInACube
7 жыл бұрын
Thanks for watching Ben!
@MartinKuzmicz
7 жыл бұрын
Great stuff - well done!
@GuyInACube
7 жыл бұрын
Thanks for watching Martin!
@goodyearspokane
2 ай бұрын
Yeah but if you have to enter the ID in excel might as well create the report in excel. I want the use to enter one ID in a text box in the PBI service report and refresh
@anjanashetty482
Жыл бұрын
Hello, I want to pass user logged in through parameter to snowflake query. Please provide inputs how to implement this scenario. Thanks in advance!
@miguelcosta9142
Жыл бұрын
A little off topic, but how do you have your power query in darkmode?
@pmack7258
6 жыл бұрын
This is a great bit of information. Still, I wish PowerBI would work like SSRS in terms of parameters:e.g. dynamically load a list/combobox of all students from the datasource. Then the user selects a few students from the list and PowerBI goes back to the datasource to retrieve the enrolment records for just those students.Does someone know how to do this? Too much to ask for?Still, great video and much appreciated.
@emmavicto
6 жыл бұрын
Hi P Mack - I'm also looking for this myself. Did you sort if out yet? If so could you share a bit of info? Thanks.
@scchottu
4 жыл бұрын
Hi Patrick, I am trying the same it is working when number of id is 5 or so, but its not working when the number id is more than an 1000
@xst-k6
3 жыл бұрын
What if a user enters an asterisk in the flat file containing student IDs? I like you video but I am not sure if I would be comfortable using this method. Thanks
@zeisslaimen1
7 жыл бұрын
great video. however at 0845 you said you will explain how to avoid that pop up window which asking permission to run the query every time, but it seems you forgot to explain how to do it.
@GuyInACube
7 жыл бұрын
Oops. Good catch. That pop up window occurs in Power BI Desktop, but when you publish to the service and do a refresh there, it won't be a problem.
@vinilsbabu3829
3 жыл бұрын
Can you do a video on establishing a live connection with mongodb?
@amit260183
4 жыл бұрын
Thank you for video tutorial. I have a question though. Is it possible to place filter in a Page of report that referring to Parameter.? Detail - I have created one Parameter say Param_P and created one Power BI report with page named Page_P, now i want to create filter on page which referring to the Param_P values, in short, can parameter will be used as a filter on visual of the report and user can change the values from the filters itself Note - Don't want to change into PBI Template, need to have normal filter referring to Parameter Thanks Amit Srivastava
@siddheshmisale3904
5 жыл бұрын
Amazing technique! Thanks for this!
@rosswaterston
7 жыл бұрын
Great video, my mind is blown!
@GuyInACube
7 жыл бұрын
That was the hope! :)
@chriscmu2002
3 жыл бұрын
Cool video. It won't work for me though. I am getting errors because the values in my parameter (server names) have hyphens in them and I cannot seem to get it to work. I can do the initial load from the stored procedure, but when I replace the source with the created parameter, it gives me a syntax error (Incorrect syntax near '-'). I assume maybe there is a way to use escape characters or something? I cannot find an answer online.
@pinakmaitra9938
4 жыл бұрын
Hi...i am currently working with parameters in power BI desktop and i was able to do that..like users will have the ability to enter values from drop down list and then submit the report.but i cannot find a way to enable " select all" values in the parameter drop down list so that users can select all the parameter values at one go.can you please help!
@madhavsrinath3640
7 жыл бұрын
Great vid, especially the rewinding noises. Question for you: I have a need to use this and this looks pretty great so far. However, I have an enterprise gateway set up with ODBC connections into DB2 databases. For each dataset, there is an instance on the DB2 server that I have to hit and they have been set up as separate ODBC connections (with different DSNs). If I use parameters to determine the specific ODBC DSN on the advanced editor, does the gateway know to connect it with the right connection based on the DSN? The difference here is that you only have 1 connection that you are able to run a stored procedure for and that connection is stored as 1 connection on the enterprise gateway. In this case, we have multiple connections within the gateway that I would like the report to refresh based on the parameter selected.
@raulsanchez3756
7 жыл бұрын
Hello Patrick, In this video, you call a SQL statement with the sentence EXEC GetStudentDetails 7780097. What is GetStudentDetails? A stored procedure? What is its sintax? Thanks, great video!!!
@GuyInACube
7 жыл бұрын
Correct. It is a stored procedure.
@tasabeehhajahmed4084
7 жыл бұрын
This is Just AWSOME!
@GuyInACube
7 жыл бұрын
Glad you liked it Tasabeeh! Thanks for watching.
@nikhil1888
4 жыл бұрын
I just started learning power hi And this video is awesome 😃
@anuragarunedlabadkar8889
6 жыл бұрын
Patrick how to use parameters created in desktop power BI in WEB power BI. I created parameters in Desktop, but after Publishing they are not visible in WEB report. Please suggest.
Пікірлер: 472