Forum Discussion

ahmedshalabyy12's avatar
ahmedshalabyy12
Helper V
1 year ago
Solved

Model.bim to data source

Dears ,   I have model.bim file extracted it from semantic model in the service .  i want to use this model.bim file and import it inside a power bi desktop file and use all the tables and relatio...
Need Help
  • ahmedshalabyy12's avatar
    ahmedshalabyy12
    1 year ago

    The Solution is replace model.bim with any new desktop pbip folder 

    inside the semantic model folder replace the model.bim 

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Thanks for the update. Based on your description, it seems you're aiming to use the .bim file in Power BI Desktop to get full access such as viewing the Data view, refreshing tables, and managing relationships, similar to working with an imported model. However, when you connect to a semantic model deployed in a workspace, Power BI creates a live connection. This allows you to use all tables and measures, but you can't refresh data or access the Data view in Power BI Desktop.

 

It's also important to note that .bim files store only the structure of the model (tables, relationships, measures), not the actual data. So, connecting to it means you're using the model live, not a local data copy.

If you need full control to edit, refresh, and manage the data in Power BI Desktop, rebuilding the model in Import mode is the best option.

 

Helpful Reference: Semantic model modes in the Power BI service - Power BI | Microsoft Learn

 

Thanks&regards,

Yugandhar.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi ahmedshalabyy12 ,

Please let me know if my response clarified things for you. If you need any further explanation or additional details, feel free to ask.

Thank You.