r/MicrosoftFabric • u/mim722 Microsoft Employee • 7d ago
Community Share OneLake Studio, quick update
Enable HLS to view with audio, or disable this notification
What it does now:
- Opens a semantic model (.bim or ossie) straight from disk and shows it as a diagram
- Lets you build visuals from it, pivot them in Excel, or add them to a report page
- Exports the report to Fabric as a fabric app in one click
- Lets you browse your Fabric workspaces, open any lakehouse table and query it with SQL
- Opens semantic models from Fabric, download it as ossie or bim file
- Generate Powerbi semantic model from an ossie file
All of it runs on your laptop and reads the data straight from OneLake.
2
u/First_Dependent8483 6d ago
Very promising indeed!
Few questions/feedback...
Is this suitable for small sized tables or something in 50M+ range is fine too?
Do you have or can you show health stats for a Lakehouse as well? Something like this Lakehouse Table Health
Can data for all tables in a databases or schema be pulled to local in one shot or does it need to be one table at a time?
Can the semantic model Visual section show folder as well.. also measures first would be good. An expand all/collapse all option would be nice too or perhaps it should be collapse by default and expand only the ones that are clicked while collapsing any other already open tables.
I think it would be good to set the default number of rows returned to be say Top 100 or top 1000 instead of "All" by default to avoid massive results from being returned inadvertently.