How You Can Version Control PowerQuery (Run Code From GitHub)

Рет қаралды 6,169

Күн бұрын

Пікірлер

@BIGorilla 9 ай бұрын

Great explanation Injae! Takes some hurdles to get there, but you got there in the end. Been fiddling with this myself before too (and spend wayyyyy too much time on it). Now for everyone to see on your channel ❤❤

@PowerBIPark 9 ай бұрын

Hahaha same! I took me almost 2 weeks to figure out the shared keyword 😂

@KAFel01 9 ай бұрын

Pretty awesome, I think your tenacity to drive a solution was the most impressive 🙏

@PowerBIPark 9 ай бұрын

Thanks! That's nice of you to say. It was a case that needed cracking 😂

@Henrik.Vestergaard 9 ай бұрын

Wow, so I can use VS Codes awesome Power query editing features, save/commit, and just hit refresh in Power BI desktop to see the result, as the query is just referring the file Fantastic, thanks mr. Park! I still have to wrap my head around the potentials of this. Also how to take use of it in combination with pbip/Developer solutions source control technics comming in Power BI (still in preview, though) ...

@PowerBIPark 9 ай бұрын

Awesome! I'm glad you see the potential with this 😁 hopefully it will save you some headaches in the future

@carloserodriguez2465 9 ай бұрын

This is really nice and very powerful, as always very good explanation. Thank you

@aragaocb 3 ай бұрын

Thanks!

@PowerBIPark 3 ай бұрын

Whoa thanks! That's the first ever for this channel :)

@aragaocb 3 ай бұрын

@@PowerBIPark This basically summarized everything that I wanted to do. I remember it coming out and seeing it on LinkedIn, but did not watch it at the time because I got a new job where I am doing Power Apps 95% of the time. I still love working with M though and solving puzzles and have written/found a lot of functions, so being able to share easily in one go would be cool. Thank you for your content! Also I regret to inform you that due to inflation that only will get you 1/2 a Big Mac Meal 😢

@aragaocb 3 ай бұрын

@@PowerBIPark thank you. I remember this video coming out, but I didn’t really dig into it because at the time I was starting a job where I do 95% Power Apps. I still love coding in M and after time saw the utility of doing something like this. I would have saved myself a lot of time if I went back to watch this earlier. Also I regret to inform you that with inflation that will only cover 1/2 Big Mac Meal 😢

@PowerBIPark 3 ай бұрын

@aragaocb worry not friend. I'm in Poland and it'll cover 2 big mac meals 😋

@vishalrakhecha2805 9 ай бұрын

Great help, it has solved one of the issues I have with my dashboard. However, I'm building a stock dashboard with a dropdown menu for stock selection. Ideally, upon selecting a stock symbol, the script would dynamically fetch data (open, close, high, low, etc.) and update the visualization, similar to how we can achieve image updates with HTML. I have access to a Python script containing the API for data retrieval. My goal is to automate data retrieval for hundreds of stocks instead of manually uploading it. In short, can Python automatically pull data from a website using an API through DAX Query or by any other mean?

@AlexAntonioSilva 2 ай бұрын

Hello, I watched your video and I really liked the content of your channel, congratulations, but from what I understand in solving the problem of dynamic fonts in the power bi service, the solution is to create a record with the query functions? Is there another way to do this? Why is it unfeasible in more complex functions?

@PowerBIPark 2 ай бұрын

If you want to have dynamic fonts, then Google api is probably the best way

@xbox4928 8 ай бұрын

Unfortunately, this method does not work for PB Service if you add a query to the SQL database ( Sql.Database = Sql.Database ) to the M-function. Do you have any ideas about this?

@PowerBIPark 8 ай бұрын

That's expected - currently my method avoids authentication entirely, and any kind of sql db will require a specified authentication method, so you'll always run into issues there unfortunately. This takes away from the possibility of using this method entirely as your main mode of backup, so in that case I would tell you to do the sql.database function through a dataglow as a specific day a source, and use this method to control the PowerQuery changes on top of it. I hope that helps

@logocreative1694 8 ай бұрын

Hi I want your little help in power bi If i create matrix table Those matrix table columns have names of employees and also manager's name now when i publish report when employees see that report they should see only their name The manager's name should not appear when the manager see the report Then everyone's name should appear It possible to we can create such a button in Power Bi, when the manager presses that button, a panel of password will appear and after entering the password, a report of employees include with manager names will appear.

@cathrerinezetadrones3169 9 ай бұрын

That’s interesting I didn’t realize setting up GIT on the workspace doesn’t include the power query changes

@PowerBIPark 9 ай бұрын

If you're backing up power bi desktop via workspace, it should include powerquery - this video is more about, say you had functions that were being used in 20 reports (like a date table that gets random holidays added over time such as in the uk) - and being able to version and update 20 reports from one place :)

@cathrerinezetadrones3169 9 ай бұрын

@@PowerBIPark ah gotcha, I’ve been managing that with common workspaces with reusable DIMs and then creating composite models for different areas. But this is definitely good to know you can do, I’m sure I’ll find a place in the tool belt. Thanks!