Forum Discussion

Joshrodgers123's avatar
Joshrodgers123
Advocate V
2 years ago
Solved

Data Warehouse Git

I have git enabled in a workspace with a few data warehouses. Something in the backend keeps triggering changes to the 

xmla.json file that cause the workspace to show that there are uncommited changes. I am not making any changes to these warehouses, nor are any other uses. It seems that it is changes the PBI_QueryOrder and switching the order of the last 2 fields back and forth. 
 
When I commit the changes, they get switched back a few hours later and then it shows uncommited changes again. How do I get this to stop? 🙂
 
See below for the changes that keep occuring:
 
"name": "PBI_QueryOrder",
"value": "[\"base_kofax_ApproverNotes\",\"stg_kofax_ApproverNotes\",\"exec_requests_history\",\"long_running_queries\",\"frequently_run_queries\",\"exec_sessions_history\",\"dbo.base_kofax_ApproverNotes\"]"
 
"value": "[\"base_kofax_ApproverNotes\",\"stg_kofax_ApproverNotes\",\"exec_requests_history\",\"long_running_queries\",\"frequently_run_queries\",\"dbo.base_kofax_ApproverNotes\",\"exec_sessions_history\"]"

 

 

data warehouse
Warehouse

16 Replies

  • AndyDDC's avatar
    AndyDDC
    Most Valuable Professional
    2 years ago

    Hi Joshrodgers123 ive actually reported this as an issue to MS Warehouse product team I've been having issues with Warehouses in Git. "Something" keeps on changing metadata unnecessarily and triggering an "uncommitted". I'll keep you posted, alternatively you can raise a support ticket yourself with all the details and MS can loook into further.

    • Joshrodgers123's avatar
      Joshrodgers123
      Advocate V
      2 years ago

      Glad to hear its not just me! I also opened a support ticket (2408070040005034) to help hopefully push things along.

      • AndyDDC's avatar
        AndyDDC
        Most Valuable Professional
        2 years ago

        Great, thank you 

  • mmilosanovic's avatar
    mmilosanovic
    Advocate IV
    1 year ago

    Hi all,

     

    It seems that this was resolved and PBI_QueryOrder is no longer being source controlled in GIT.

     

    Best regards,

    Milos