fbpx

Enable QUERY FOLDING for native queries in Power Query / Power BI

We have usually said that if you use a native query, you break query folding in Power Query. Interesting. There may be a way to enable it in Power BI! Patrick shows you how. Chris Webb Blog: https://blog.crossjoin.co.uk/2021/02/21/query-folding-on-sql-queries-in-power-query-using-value-nativequery-and-enablefoldingtrue/ Query folding guidance in Power BI Desktop https://docs.microsoft.com/power-bi/guidance/power-query-folding Visualise your Power BI Refresh https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Enable QUERY FOLDING for native queries in Power Query / Power BI2021-05-06T04:43:14-05:00

Avoid Left Outer Joins with DirectQuery in Power BI

By default, your DirectQuery queries, in Power BI, will send a LEFT OUTER JOIN and could make your DBA not happy! Patrick shows you how you can change this to an INNER JOIN and put your DBA back into that happy space.

Avoid Left Outer Joins with DirectQuery in Power BI2021-05-05T06:41:33-05:00

Source Control with Power BI – Can it be done?

Can we use source control with Power BI? We get this question ALL THE TIME! Adam walks you through what your options are and how this works today with Power BI. ALM Toolkit: http://alm-toolkit.com/ Tabular Editor: https://tabulareditor.com/ Latest updates for Deployment Pipelines: https://powerbi.microsoft.com/blog/announcing-new-deployment-pipelines-capabilities/ Source Control Idea https://ideas.powerbi.com/ideas/idea/?ideaid=c73d887d-042e-4ca0-8216-bcb09bd282ab

Source Control with Power BI – Can it be done?2021-04-29T07:07:02-05:00

Report BURSTING with the Power Platform

Automate data driven subscriptions with the Power Platform using Power BI and Power Automate! Patrick shows you how to quickly setup a report bursting option for your reports.

Report BURSTING with the Power Platform2021-04-28T03:50:38-05:00

🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (April 24, 2021) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! With special guest, Kasper de Jonge! Connect with Kasper: Twitter: https://twitter.com/Kjonge YouTube: https://www.youtube.com/channel/UC40_DLjKbvxkhMc7N4UevkA Website: https://www.kasperonbi.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:" [...]

🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (April 24, 2021) (Member Chat 2nd Half)2021-04-20T07:07:39-05:00

Best kept SECRET in Power BI??? You tell us!

Have we found the best kept SECRET in Power BI? Adam saw this recently and was BLOWN away! Zooming in can help with presenting in business settings and anywhere else. Here are a few things you can use to make that presentation better with Power BI. ZoomIt: https://docs.microsoft.com/sysinternals/downloads/zoomit DAX Studio: https://daxstudio.org/

Best kept SECRET in Power BI??? You tell us!2021-04-22T06:26:45-05:00

🔴 Let’s continue the big data discussion with SQLBI (April 17, 2021)

Let's keep the big data discussion going with Power BI and the folks from SQLBI - Marco & Alberto! Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats [...]

🔴 Let’s continue the big data discussion with SQLBI (April 17, 2021)2021-04-16T12:29:19-05:00

Mastering Power BI Bookmarks

goes through the options to help you master bookmarks! Taking your reports to the next level! Bookmark Documentation: https://docs.microsoft.com/power-bi/create-reports/desktop-bookmarks Download Sample

Mastering Power BI Bookmarks2021-04-14T05:30:27-05:00

🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (April 10, 2021) (Member Chat 2nd Half)

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 [...]

🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (April 10, 2021) (Member Chat 2nd Half)2021-04-07T08:03:22-05:00
Go to Top