Forum Discussion

PHO's avatar
PHO
Frequent Visitor
1 year ago
Solved

Testing: Find connections and relationships

If columns, measured values or tables calculated in the semantic model are changed in powerbi, this always has an influence on the reports.
How can I create an export in which I enter "posting_date", for example, and then all visuals from the report in which this table is used are output?

I basically want to quickly find out what changes they have an influence on or result in an error.
One Idea was with DAX Studio 

EVALUATE
    INFO.VIEW.MEASURES()

there I can find out the error state. But this is noth enough. 

Need Help
  • Deku's avatar
    Deku
    1 year ago

    There are no linkage from model to report so DMVs will not help. You will have to scan the report.json or pbir Def file to find the references

4 Replies

    • PHO's avatar
      PHO
      Frequent Visitor
      1 year ago

      Thanks Deku, that's definitely very interesting and goes in the direction I want to go.
      I don't need GIT yet, because I don't need a change history.

      What I am currently looking for is the export of dependencies:
      So for example if I change “posting_date” and it now has a different format or I deleted it, I want to be able to export:
      Where it is used everywhere on the report in visuals without having to click through.
      And whether, for example, “upload_date” (“posting_date” + 12 days) depends on it and where it is used.

      Translated with DeepL.com (free version)

      • Deku's avatar
        Deku
        Super User
        1 year ago

        There are no linkage from model to report so DMVs will not help. You will have to scan the report.json or pbir Def file to find the references

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PHO,

    Thanks for reaching out to the Microsoft fabric community forum.

     

    It looks like you want to keep track of all the changes happening in the report so that you can find what caused an error. As Deku alreaady responded to your query, please accept it as solution if it answers your query.

     

    I would also take a moment to thank Deku, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.