Forum Discussion

Sidhant's avatar
Sidhant
Icon for Advocate V rankAdvocate V
1 year ago
Solved

Single data model referred by multiple reports

Hi everyone, In the past couple of weeks, I was going through Power BI report creation progrmatically (i.e. creation of schema {tables and its respective columns}, visual creation by inferring a Met...
General Comment
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi Sidhant,

     

    As you and rajendraongole1 pointed out, the currently supported and recommended approach is to publish a semantic model to a Power BI workspace and have other reports connect to it via a live connection this helps with centralization, governance, and reusability.

    I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement.

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support.

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi Sidhant - PBIP currently does not support referencing a shared or external semantic model folder across multiple report projects directly on the file system. Each .pbip project expects its own SemanticModel folder containing a model.bim.

 

you can publish the shared semantic model to a Power BI workspace.
New .pbip reports are created using a Live Connection to that semantic model.
When exporting such a report to PBIP, it will not contain a SemanticModel folder, but just the Report folder + .pbip file.This is the only officially supported way to reuse models across reports currently.

 

Check the above and i hope this helps.

  • Sidhant's avatar
    Sidhant
    Icon for Advocate V rankAdvocate V
    1 year ago

    Hi rajendraongole1 & v-prasare  ,
    Thanks for the response, so what you are saying is every report needs to have its own model.bim file. and we just upload our semantic model onto Power BI service (Fabric) and then the reports that are referencing they can do that by using live Connection.
    But I was thinking is there any way that we can have a structure like:
    Structure that I was referring to
    Since I am thinking of automating the report creation process, so if 'n' reports are having the same model.bim (i.e. the same schema structure; only the report is making use of different columns).
    The other question I had is it possible to have something like:

    As I planning to create a Power BI Report through some script (Python) based on the MetaData (like the table and column details, what visuals are required).

    Regards,
    Sidhant.