Testing: Find connections and relationships

[PHO]

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. 

[v-mdharahman]

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.

[Deku]

If you want to keep track of changes you need to use git. There is no way to query to see changes as no history is kept.

You can check for broken visuals using playwrite

https://www.youtube.com/live/Ru5yYZiqvso?si=DTXl037sxdrxVYCC 

[PHO]

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 · Accepted solution]

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