none
Refreshing definition of shared queries

    Question

  • Hi,

    I've been playing around with shared queries in the Power BI Preview version of Power Query. It seems as though once I have shared a query and then imported it and used it in another worksheet, the definition of the query is fixed in that second worksheet; I can update the shared query and subsequent uses of that shared query will reflect the changes, but the update doesn't affect existing queries.

    To give you an example of how it seems to be working: a data steward created a shared query that returns 10 rows of data. User A imports that query in a worksheet and gets 10 rows back. The data steward then updates the shared query so it now returns 20 rows of data. When User B imports that query, they get the 20 rows back. However, User A still gets the original 10 rows from their imported query, even when they refresh.

    It seems to me that when you import a query, you take a copy of it and embed it somewhere inside the worksheet and there's no way of updating it after that. Am I right, or am I missing something?

    Thanks,

    Chris


    Check out my MS BI blog I also do SSAS, PowerPivot, MDX and DAX consultancy and run public SQL Server and BI training courses in the UK

    Thursday, October 3, 2013 9:25 PM

Answers

All replies

  • Hi Chris,

    That's correct: when sharing a query into the Data Catalog, you are sharing a copy of such query; when a user searches and uses a query from the results, they are making a local copy of the query into their workbook; when a shared query owner makes updates to the query, these updates overwrite the definition of the shared query in the catalog, but doesn't propagate (or notify) changes to existing copies of the query.

    Thanks,
    M.

    Monday, October 14, 2013 3:17 PM
  • Thanks Miguel,

    The more I think about this, the more I think it's important that the end user has the option to update their local copy of a query if the shared copy has been updated in the catalog. For example, if the underlying data source changes and the data steward fixes the query, you would want end users to be able to get the fixed version as quickly and easily as possible.

    Can I put in a request for this functionality to be included in a future version? 

    Thanks,

    Chris


    Check out my MS BI blog I also do SSAS, PowerPivot, MDX and DAX consultancy and run public SQL Server and BI training courses in the UK

    Monday, October 14, 2013 4:16 PM
  • Fair thing to ask... Thanks for your feedback, Chris!
    Tuesday, October 15, 2013 10:23 PM