Certify Queries

[Power Query version 2.10]

Users often are not sure about the credibility of the data they find within their enterprise, and lack the necessary information to identify the appropriate data to use for their analysis and reporting.

Certification of queries enables you to address the issue of lack of trust in the data available to the users. Using Power Query, authorized users (such as data stewards) can certify a query while sharing it or by editing an uncertified shared query to let the users know that they can trust the underlying data sources referenced by the query in Power BI for Office 365.

In this article


Who can certify a query?

Only users who are members of the data steward group role in Power BI can certify queries. Power BI administrators can add users to this role using the Power BI Admin Center. For more information, see Add Users to the Data Steward Group.

How to certify a query?

You can certify a query while sharing a query, or by editing an uncertified shared query in Power Query. To certify a query, you must select the Certify this query for others check box while sharing or editing a shared query.

To certify a query

  1. In the Share Query dialog box, check Certify this query for others.

 Note    The Certify this query for others check box will only be visible if your user account is a member of the data steward group role.

For more information about sharing or editing a shared query, see Share Queries and View and Update Your Shared Queries.

Top of Page Top of Page

What happens when you certify a query?

When you certify a query in Power Query, a certified icon (Certified Query icon ) appears alongside the query name in the Shared pane, Online Search pane, and in the preview fly out screen of the shared query in Power Query to let users easily distinguish a certified query.

Top of Page Top of Page

Related Topics

Find and Use Shared Queries

View Your Shared Queries in the Manage Data Portal

Replace Your Existing Shared Queries

Delete Your Shared Queries

View Usage Analytics for Your Shared Queries from Power Query

Understanding the Role of Data Stewards in Data Management

Data Management Experience in Power BI for Office 365 Help

 
 
Applies to:
Excel 2013, Power BI for Office 365