I may be using the term Data Catalog somewhat liberally here, but since we don’t have the official definition of this term yet, I hope I don’t get myself in too much trouble here.
As I have been experimenting with various features of Power BI, I have been creating and sharing queries in the Data Catalog; however, at some point I started wondering what sort of governance may be necessary to implement so that an organization does not end up with hundreds or thousands of random of queries. At a minimum I thought it would be nice to have a list of queries already defined. However, having spent quite a bit of time on the Power BI Admin center and having clicked and explored every option available there I could not find a way to see a simple list of the shared Power Queries. After randomly stumbling around I found the Manage Data Portal.
I eventually found several way to get to it. The easiest one is to click on Power Query and then Shared
Now you should see your shared queries in the search results list
If you “peek” at the data by mouse over the query or right clicking and picking the “peek” option a screen like the one below will appear
If you select View in Portal option, you will be taken to the Manage Data Portal.
I thought I was somewhat of a clunky to get to this page but I still cannot find a faster way to it from the Admin Center. I decided to hack around the help section and see if I can get some answers that way. Pasting “usage analytics” in to the search box brought me to this help page that does a great job of explaining this feature and also contains more links with additional information.
I am still trying to find a way to delete the unused queries from the data catalog but that will be a topic that will be covered in a different post.