Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Asset library Power BI...
Finance forum
Suggested answer

Asset library Power BI report model versioning

Posted on by Microsoft Employee

Does anybody know how to add version in the Power BI report model Asset Library? It seem that is not possible to do it.

1033.deploy-pbi.png

  • BurakSahin Profile Picture
    BurakSahin 3 on at
    Asset library Power BI report model versioning
    Is there any update for this topic? I need to update all reports and rls settings in every update for the pbix file. I've found this topic but over years no solution seems. I guess I do something wrong. Maybe there is no solution yet?
  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: Asset library Power BI report model versioning

    Hi tschris,

    As far as I know there is no such feature, you have to create multiple PBIX files for different scenarios.

    And you could ask for more suggestions in Power BI forum:

    https://community.powerbi.com/

    Maybe you can consider another solution. If you just need the data in D365FO, have you considered using BYOD?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Asset library Power BI report model versioning

    Hello Jani,

    the requirement and issue we face is the following:

    1) We add PBIX files in the Asset library which are using direct query connection to the localhost server and the DW DB of D365. These files are developed in D365 cloud-hosted development box environments

    2) These files serve as Power BI datasets where all DAX measures are implemented e.g., YTD Sales, YTD Quantity, etc. All RLS rules are defined in the Power BI dataset as well, e.g., RLS rules showing only, domestic sales, or international sales, or all sales etc

    3) We deploy this PBIX files (Power BI datasets) via the respective environments (TEST, PROD, UAT) in LCS to the powerbi.com platform using a services account

    4) We share the deployed dataset of the service account in powerbi.com to our users having a Power BI Pro license in the organization

    5) Then users create Power BI reports consuming the Power BI dataset deployed via our service account and they consume these reports via the powerbi.com portal and the Power BI mobile App

    6) We also publish Power BI reports using the deployed Power BI datasets to Power BI Apps

    The issue starts if we need to add/modify either a DAX measure or a RLS rule. Without versioning we cannot redeploy the new Power BI dataset to be used from the existing reports. Instead we have to add a new PBIX file in the Asset library, deploy it via LCS to the respective environment as a new Power BI dataset and edit all existing reports to use the new dataset. Roll-back is also following the same process.

    Thus, it would make sense to have versioning of Power BI assets. Did I help you to better understand the requirement and the issue we try to address?

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,470 Moderator on at
    RE: Asset library Power BI report model versioning

    Hi Tschris,

    Can you please describe the requirement/issue in detail?

    Why do you want to add a version in the Asset liberary?

    Did you created an updated PowerBI report and wanted to embed it into the Finance & operation?

    Thanks,

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans