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

Рет қаралды 4,242

Күн бұрын

💠Get all the code:
github.com/PowerBIPark/PowerB...
⏰Timestamps:
0:00 - Intro
00:30 - From a Local File
02:37 - From the Web
05:56 - Dealing with Shared keyword
11:44 - Adding Parameters
15:10 - Creating a PQ Library
📎Links:
→ gorilla.bi/power-query/date-t...
→ / powerquery_call_custom...
→ github.com/PowerBIPark/PowerB...
→ powerquery.how/expression-eva...
→ www.thebiccountant.com/2018/0...
→ blog.crossjoin.co.uk/2016/08/...
→ www.kerski.tech/bringing-data...
→ github.com/acaprojects/m-tool...
⭐I'm making all PBIX files from my channel available for supporters (soon)
/ powerbipark
😉Get in touch
/ injae-park
Thanks for watching!
#PowerBI #DataAnalytics #BusinessIntelligence #powerquery

Пікірлер: 17

@BIGorilla 3 ай бұрын

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 3 ай бұрын

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

@KAFel01 2 ай бұрын

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

@PowerBIPark 2 ай бұрын

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

@carloserodriguez2465 3 ай бұрын

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

@writetoprithvi 14 күн бұрын

Just awesome

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

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 3 ай бұрын

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

@logocreative1694 2 ай бұрын

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.

@xbox4928 2 ай бұрын

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 2 ай бұрын

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

@vishalrakhecha2805 2 ай бұрын

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?

@cathrerinezetadrones3169 3 ай бұрын

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

@PowerBIPark 3 ай бұрын

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 3 ай бұрын

@@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!

@xbox4928 3 ай бұрын

Does this work only for public github repositories? Am I right?

@PowerBIPark 3 ай бұрын

Depending on the authentication, should work with most websites