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

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

3 ways to REDUCE DATA In Power BI Desktop (No Premium needed!)

Sometimes you want to reduce data in Power BI Desktop so it's easier to work with. Then work with all the data in the Power BI Service. Patrick shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium!

3 ways to REDUCE DATA In Power BI Desktop (No Premium needed!)2021-03-24T07:25:55-05:00

Create your first Power BI report

New to Power BI? Adam helps you get started with creating your first Power BI report in Power BI Desktop! Start your journey the right way! Guy in a Cube Blueprint Course: https://guyinacu.be/pbiblueprint Star Schema: https://docs.microsoft.com/power-bi/guidance/star-schema Star Schema Book: https://amzn.to/38JQJqq Definitive Guide to DAX: https://amzn.to/2MTIi3h Power BI Blog: https://blog.powerbi.com Power BI documentation: https://docs.microsoft.com/power-bi Power BI [...]

Create your first Power BI report2021-01-21T08:17:27-05:00

Do I need to be an expert in Power Query M?

Maybe you've heard of Power Query M in Microsoft Excel, Power BI or something else. Do you really need to be an expert in that? Or even use it? Patrick helps to ease your mind!

Do I need to be an expert in Power Query M?2021-01-20T07:01:42-05:00

A look at Visual Data Prep in Power BI dataflows

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/

A look at Visual Data Prep in Power BI dataflows2020-11-26T07:48:23-05:00

Power BI community posts… (Roundup | July 6, 2020)

Thanks for watching this week's Power BI news roundup! 2 Minute Tuesday: https://guyinacu.be/userprincipalname Tech video: https://guyinacu.be/whatisrls 📢 Become a member: https://guyinacu.be/membership Sources Why Is Power BI Running My SQL Query Twice? (@cwebb_bi) Analyzing Performance Analyzer trace in DAX Studio (@marcorus) The ultimate button resource for Power BI by Tableau Zen Masters (@curbalen) [...]

Power BI community posts… (Roundup | July 6, 2020)2020-07-06T07:41:18-05:00
Go to Top