We get a lot of questions about Power BI dataflows and when to use them. Patrick explores a use case that screams for using dataflows! Are you taking this approach?
Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let's have a look! Introduction to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview Comparing dataflows to datamarts https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts When to use dataflows https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows Dataflows with benefits https://ssbipolar.com/2022/05/25/dataflows-with-benefits/
What's up with the wait time in Power BI Dataflows? Do we just live with it? What's going on and what can we do about? Adam, has you covered! Understanding and optimizing dataflows refresh https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh
Let's go into Adam's mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING! Power Query M function reference https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference
Did you know that there are two Dataflows connectors in Power BI? What's the difference? Adam takes a look and explains what is going on.
Are you wanting to use Incremental Refresh in Power BI but need to use ODBC, native queries or something that doesn't fold properly? Adam shows you a solution for Power BI Desktop and Power BI dataflows! Native Queries https://docs.microsoft.com/power-query/native-database-query Using Incremental Refresh with dataflows https://docs.microsoft.com/power-query/dataflows/incremental-refresh Configure Increment Refresh for Datasets (includes DateKey function) https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-configure
Join us live as we answer your questions about Power BI! With special guest, Matthew Roche! Connect with Matthew: Twitter: https://twitter.com/SQLAllFather YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ Website: https://ssbipolar.com/ 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup202 Patrick's tech video: https://guyinacu.be/rdlmigration Adam's tech video: https://guyinacu.be/sharebookmarks 🔴 Live Replay: https://guyinacu.be/live036 📢 Become a member: https://guyinacu.be/membership Sources Dataflows Power Automate connector: fully automate your data refresh (@maraft_per) Exploring new composite models in Power BI Desktop - Unplugged #1 [...]
Have you noticed the updates Power BI dataflows has had recently? Patrick explores Visual Data Prep which helps you craft your transforms in Power Query Online. Blog: https://powerbi.microsoft.com/blog/announcing-visual-data-prep-public-preview-diagram-view-in-power-query/
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup198 Patrick's tech video: https://guyinacu.be/imagesinpowerbi Adam's tech video: https://guyinacu.be/serviceprincipals 🔴 Live Replay: https://guyinacu.be/live032 📢 Become a member: https://guyinacu.be/membership Sources Formula engine and storage engine in DAX (@marcorus) Power BI Premium per user public preview now available Announcing Preview Availability of [...]