Ed Freeman

@kevchant @kevarnold @PowerBIWeekly @MSFabricconf Argh sorry about that, Kevin. My mistake - I pressed the wrong thing (but I promise I had you in mind when adding your article!)

@MicahDail Just a caution that if you have many rows and deep hierarchies (along with many measures), then perf on the matrix suffers. So worth testing.

@MicahDail It might be worth looking into the Inforiver matrix (if you have the appetite). We had a very similar scenario and found that Inforiver had very nice (and flexible) ragged hierarchy handling, and made the measures simpler. (Btw I/my company has no affiliation with Inforiver!)

Hey all my #PowerBI peeps! Anybody know the inside scoop on when HideBlankMembers will actually work? I'm tired of having PBI visuals with blank children in ragged hierarchies. Thanks!

Turbocharge your Data Science workflow with Microsoft Fabric with @barry_j_a_smart🛫 Microsoft Fabric's SaaS platform empowers full-stack data scientists with tools like MLflow and Semantic Link to revolutionize machine learning model development🛩️ sqlbits.com/attend/the-age… pic.twitter.com/hA7mj0YJ7L

SQLBits 2024 Workshop - DataOps: How to Deliver Data Faster and Better with #Microsoft Cloud from @edfreeman_ buff.ly/3vC6g9E #Azure

How To Actually Make Decisions When Architecting a Data Platform from @edfreeman_ ☺️ Introducing tried-and-tested methods to help you make decisions when architecting a Modern Data Platform amongst a sea of options🛫 #How_To_Actually_Make_Decisions_When_Architecting_a_Data_Platform" target="_blank" rel="nofollow noopener">sqlbits.com/attend/the-age…

Super excited to be speaking at #SQLBits2024 about #DataOps with @barry_j_a_smart. If you'd like to level up the quality of your Data Platform, then this training day's for you!

@MrAndyCutler Have they ever logged into the Power BI Service?

📢 #MicrosoftFabric End-To-End demo Part 4: Creating a OneLake Shortcut to ADLS Gen2 from @edfreeman_ endjin.com/what-we-think/…

📢 EP3 of @edfreeman_ #MicrosoftFabric end-to-end demo series. Ingesting 5GB into a Bronze Lakehouse using Data Factory. youtube.com/watch?v=yptYlW…

It's pretty exciting finally being able to talk about this. We have plenty more content on the way! #MicrosoftFabric

@mim_djo @DeltaLakeOSS The cost of streaming data back to the Synapse Studio web client can be non-trivial. Anyway, I'm not sure it'll change your original conclusion regarding single vs multi-node architectures😀

@mim_djo @DeltaLakeOSS Depending on the size of the resultset, be careful using Synapse Studio timings as a direct indicator of performance. See whether using a local client (SSMS/Azure Data Studio) makes a difference. I've had some queries be an order of magnitude faster for operations like these.

#duckdb vs #azuresynapse serverless querying a very small @DeltaLakeOSS table from azure storage, 500 ms vs 13 second Single node for the win 🤡🤡

@alexdupler @ehansalytics @DOtykier From a Power BI Desktop perspective, doesn't the "Pause visuals" functionality brought in a few months ago give you that middle ground, to some extent? #pause-visuals" target="_blank" rel="nofollow noopener">learn.microsoft.com/en-us/power-bi…

@ehansalytics @DOtykier There is clearly some kind of middle ground nirvana. Like a pause evaluation or limited evaluation mode so you can make a batch of changes without waiting or via script and then all the automated checks run once.

It is amazing how much work the #PowerBI desktop app does in the background for you. Examples of what you have to do manually using Tabular Editor: ✔️Adding a column to a table, you have to set the field type and the source column that data comes from, which is usually the same name, but could be different I suppose. ✔️Adding or modifying a relationship requires recalculation of the model. ✔️Adding a shared expression (code in Power Query that load is set to disabled) require setting the “Kind” property to M. ✔️Changing the DAX of a calculated table or column requires recalculation of that table These are just a few examples. Next time you make a change to the model in some way and get the spinning “Working” dialing box, it’s likely checking, changing, and validating dozens (hundreds?) of settings and calculation states.

@waynealytics See: twitter.com/yelperalp/stat…

Anyone located the new theme schema that #PowerBI is publishing to lint your theme json file against?

@mthierba Am I missing something, or has *that* sentence now been removed? 🤔

1st issue of @AzureWeekly for 2023 almost done. It's a whopper. 220+ articles. The emergent theme from the community is "cutting the cost of #azure spend" 🔎💰

Auto-statistics for CSV datasets in SQL Serverless - nice! Great work from the #AzureSynapse team. #SynapseInfluencers

@GiveBloodNHS Hi there, I'm due to give blood next Monday. Will the donation centre still be open (given that it's a bank holiday for the Queen's state funeral)? Thanks!