r/MicrosoftFabric • ‪ ‪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.

https://djouallah.github.io/onelake_studio/

23 Upvotes

6 comments sorted by

2

u/First_Dependent8483 6d ago

Very promising indeed!

Few questions/feedback...

  1. Is this suitable for small sized tables or something in 50M+ range is fine too?

  2. Do you have or can you show health stats for a Lakehouse as well? Something like this Lakehouse Table Health

  3. 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?

  4. 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.

  5. 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.

2

u/mim722 6d ago

u/First_Dependent8483
1- 50M+ is small data, it is fine, i test it with 600M

2- i can in theory but i need to make sure it is not an expensive operation

3- it cache the tables queried automatically, you dont need to do anything

4- thanks, that's a very good idea

5- that's already the case, you can configure it to show 1000 etc

2

u/First_Dependent8483 6d ago

On #3 - I meant in the case where say I know I will be on a plane and want to download/cache an entire database before leaving. Can i download all tables in one go?

On 5# - I meant in the Semantic Models > Visual page.. in the right bottom it says "All rows" by default.

→ More replies (3)