Ivan Bondarenko

New PBIX file download options in the #PowerBI service!

You can now view your deployment pipeline history in the #PowerBI service!

@Datatouille @EscobarMiguel90 @mllopis Great news indeed!

The beginning of a NEW ERA 🔥 In a near future, we should be able to use Power Query as a "real" ETL with #PowerBI Dataflows Gen2 💡 For example: snapshoting data in SharePoint or Azure Data Lake, inserting/updating rows in Azure SQL Database⚡️ 👉 learn.microsoft.com/en-us/power-pl…

I'm excited to announce that the latest set of Excel functions are generally available. 🎉 They simplify common text manipulation tasks and unlock dynamic array scenarios. TEXTBEFORE/AFTER, TEXTSPLIT, EXPAND, TAKE, DROP, V/HSTACK, CHOOSEROWS/COLS, TOROW/COL and WRAPROWS/COLS.

New DAX function in #PowerBI: EvaluateAndLog. This will be incredibly useful for debugging! See the great Jeffrey Wang’s blog for details: pbidax.wordpress.com/2022/08/16/int…

Have you ever tried the Cluster values feature in #PowerQuery? Cluster values automatically create groups with similar values using a fuzzy matching algorithm, and then maps each column's value to the best-matched group #TransformTuesday docs.microsoft.com/power-query/cl…

Just updated "Literal Attributes" in Power Query M Primer (part 21) - Identifier Scope & Sections. Now features a slightly more commonplace use case for literal attributes. #literal-attributes" target="_blank" rel="nofollow noopener">bengribaudo.com/blog/2021/07/1… #PowerQuery #MLanguage

How can you hide 0 in #DAX in #PowerBI? I'm showing one bad and two better ways: xxlbi.com/blog/power-bi-…

Besides potential performance degradation, you should avoid filtering whole tables in #DAX in #PowerBI because sometimes you may get unexpected results: xxlbi.com/blog/power-bi-…

#PowerQuery Refresh is now generally available for selected data sources - techcommunity.microsoft.com/t5/excel-blog/…

A bunch of formatting improvements landed in the #PowerBI service. Guess what this means for Power BI Desktop?

Great news!

My next Ask Skillwave livestream with @ExceleratorBI is happening on Mar 16 @ 2pm PDT (which is Mar 17 @ 8am for Matt). Join us here on the @skillwave_ account, or on YouTube at skw-t.com/yt. If you have a question or topic idea, submit it at skw-t.com/askus

@NicoleHorwitz Hi Nicole, thanks! No guides unfortunately. I feel like I need to record a video to explain how to work with it. Will try to spare some time on that soonish

Refreshing #Excel #PowerQuery queries with VBA and #PowerAutomate for desktop blog.crossjoin.co.uk/2022/02/27/ref…

Come join Reid and me tomorrow when we do a live stream/chat about the fabulous InfoRiver custom visual. See how easy it is to get "spreadsheet like" features right inside Power BI.

Excited to share that I'll be speaking at #sqlbits this year. Looking forward to sharing some #powerbi #maps magic. Celebrating by playing Space Invaders inside Power BI! Have a go: icon-map.com/pbix/SpaceInva…

Heads-up: the Microsoft Certified: Data Analyst Associate certification (exam DA-100) will be renamed to Microsoft Certified: #PowerBI Data Analyst Associate (exam PL-300): techcommunity.microsoft.com/t5/microsoft-l…

Native sparklines in #PowerBI service!!!

In #PowerBI dataflows, you can now select the data type when writing your #PowerQuery custom column formula! The feature uses Table.TransformColumnTypes instead of the fourth argument of Table.AddColumn.