Microsoft Data Platform News 2024 - Week 40
Luká? Karlovsky
Fabric | Power BI | Power Query | SQL | PySpark | Data | Powershell | DWH | Excel | VBA | Instructor
Content
Fabric
Fabric
Performance Analysis of V-Ordering in Fabric Warehouse: On or Off?
V-Order is Microsoft’s “special sauce” to further optimise data within Parquet files and is a read optimiser feature. V-Order also helps optimise Power BI DirectLake functionality. However, V-Order comes with an overhead when writing and can be deactivated/activated on a table in a Lakehouse. Now in Fabric Warehouse we can disable V-Ordering, however this is on the whole Warehouse. We can’t choose which tables, plus it can’t be reversed so once you switch if off in a Warehouse, that’s it.
?
Thoughts on workspace design in Microsoft Fabric — part 1
As for the “customizable” element of the self-service BI scenario, the development of these semantic model can be “delegated” or customised by other domain specific content creators by sharing it to the appropriate report/semantic model developer using build and modify permissions. Build will allow them to create reports using this model and modify will (as you expect) allow them to modify the model (e.g. define relationships, measures etc) but won’t allow them to add additional tables to the model.
?
领英推荐
Microsoft Fabric - Google BigQuery
We have seen different solutions to enable efficient analysis and decision-making analyzing GCP data in Power BI
Luká? Karlovsky
FABRIC | Power BI | Power Query | SQL | Data | DWH | Excel | VBA | Instructor
Joyful Craftsmen
Joyful Craftsmen is a data design and data engineering team. We’ve been learning and building data solutions since 2014. We focus on our vision to do the data craft as smartly as reachable. Humanity, teamwork and joy is part of our game, regardless you are our partner or one of us. Altogether we are valued for delivering cutting edge data solutions, on time, in top quality.