Power BI CI/CD, the REST API, and VSCode (with Gerhard Brueckl)
ฝัง
- เผยแพร่เมื่อ 20 ส.ค. 2024
- Since its release in 2015, Power BI has quickly become one of the major and widest spread reporting tools on the market. It is used for self-service BI, team BI and also enterprise BI solution of which especially the latest has very specific requirements when it comes to managing deployments and releases. We would like to discuss the typical use-cases and problems that you will encounter when trying to use the traditional approaches for CI/CD and release management with Power BI.
GUEST BIO 👤
Gerhard is a data solution architect at Paiqo GmbH in Austria. He has been working with Microsoft Data & BI tools for over 15 years and is still continuously learning. In all those years he was always shared his knowledge with the community in forums, his personal blog or when speaking at conferences or user groups. Over the last years he focused more on big data and cloud processing in Microsoft Azure but always maintained the link to his roots in BI.
RELATED CONTENT 🔗
Twitter -- / gbrueckl
Blog -- blog.gbrueckl.at
LinkedIn -- / gbrueckl
GitHub -- github.com/gbr...
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consult...
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsu...
Blog -- www.havensconsu...
Blog Files -- www.havensconsu...
Files & Templates -- www.havensconsu...
Consulting Services -- www.havensconsu...
Online Course -- www.havenscons...
Contact & Support -- www.havensconsu...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #devops #cicd #azure #vscode
My god... that's amazing, last time was so enthusiastic about a new Power BI toy since March when Mathias announced TMDL. This should save so much time for my fellow leads and our ops team... Going to test it for a few days and then share with the rest of the team. That's basically a Power BI REST API wrapper in VS Code. I wrote a few PS scripts using this API but it took a couple of days and it's not very straightforward what are all the available calls and parameters. This should also help in learning the API. I'm trying to follow all the main new stuff happening in the Power BI ecosystem and this almost flew under my radar. Definitely deserves more attention and kudos!
In the next release (coming soon!) we will also include a TMDL browser that allows you to view and change(!) an online model via TMDL
@@gbrueckl That’s great, more and more tools start providing support for TMDL. I’m hoping that Microsoft will soon release a preview feature to toggle the .pbip representation to TMDL. Waiting for that to proceed with CI/CD implementation in my org.
This is pretty informative session, i have to upgrade few things 🤩🤩🤩🤩🤩🤩🤩🤩🤩🤩 , Thankyou Reid and Gerhard love from India
You’re welcome 😊
Great video ! Thanks . Quick question what if I have reports datasets and dataflows in 3 different workspaces. How pipelines will help deploy and point to correct sources ?
Is there a confirmation window when clicking on the X to delete a workspace or unassign from a capacity? That button is dangerously easy to miss click. Deleting workspaces, especially in production, is a very rare event and maybe there is no need for that extreme level of convenience for this kind of actions...
No confirmation, just tested. You just refresh the tree view and the object is no more. Way to dangerous to be used in production right now, thankfully I was testing on a dev artifact. Great potential, but I would suggest to put more thought into the safety and governance, with great power comes great responsibility :D. Definitely will be following the evolution of this tool.
Looks like he's addressed this in his upcoming build :)
Is it a way to see the tables and the script inside each Dataflow?
Unfortunately no, as there are no APIs that would expose detailed information about a dataflow
we could techically provide you the JSON definition of the dataflow via the API, but i am afraid thats all we can (technically) doo
Does he have a course to use the power bi vs code extn
Great question! I'd recommend reaching out to him on LinkedIn to check. His contact info is in the video description :)