Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Asset library Power BI report model versioning

(1) ShareShare
ReportReport
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 4 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,352 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,511 User Group Leader 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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans