Forum Discussion

ramdasp's avatar
ramdasp
Regular Visitor
6 years ago

Impact Analysis of Source System Changes

Hi,

 

If a column name in the source system changes, how do I impact assess all my Power BI Reports to find out which report will be impacted by this source system change.

 

On the Power BI Service, are the source system table and column details held in any metadata respository?

 

Kind Regards

 

Ramdas

Need Help

4 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi ramdasp ,

     

    For live connection, Power BI caches the last state of the report visuals so that when you view the report again, Power BI does not have to query the Analysis Services tabular model. When you interact with the report, such as by changing a report filter, Power BI queries the tabular model and updates the report visuals automatically. If you suspect that a report is showing stale data, you can also select the Refresh button of the report to trigger a refresh of all report visuals.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • ramdasp's avatar
      ramdasp
      Regular Visitor
      6 years ago

      Hi,

       

      My query was how to impact asess source system table/column changes and verify which PBI report will be impacted by it.

       

      Kind Regards

       

      Ramdas

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi ramdasp ,

         

        Unfortunately, there is no such feature like this.

        It is suggested you to submit your idea to help improve power bi.
        https://ideas.powerbi.com/ 


        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.