Azure Data Catalog Integration?

[AlongTheseLines]

Are there any details available on what integration with the Azure Data Catalog might look like? Will it support query sharing?

[jbocachica]

From PowerQuery, you can access Azure Market Place to get data.

Regards

[andre]

Right now Azure Data Catalog does not have much to do with Power BI Data Catalog.  Right now the only way to see data from Azure Data Catalog is Excel.  I would hope that the two products get integrated somehow at some point so that we can crowd source the meta data for the published PQs and at the same time be able to consume that Azure Data Catalog datasets which would almost behave like a data virtualization scenario.

Imagine, not having to have any drivers for any data sources and just letting Azure Data Catalog take care of the plumbing.  Right now it's more of a dream than reality but if we could get a sigle data source to connect to for all corporate data and a single place to manage all corporate data security, I think this product would take the market by storm.

[timrodman]

I just watched a video on Azure Data Catalog and it looks pretty cool. It looks like you can open direcly in SSRS, not just Excel (click here).

Do you know the answer to these questions about Azure Data Catalog:

1. When it opens in Excel, does it function as if you connected to SSAS?
2. Can you organize the data sets into folders/subfolders? 

[andre]

I just tried it again and the only option that I see to view the data is Excel as you can see in the image below.

When you click on Excel, an ODC file is generated and that's what Excel uses to connect to the data set and explore it in a Pivot Table.  You don't need folders/subfolders because the tool is more of a portal with search capabilities but I guess you could use Tags as folders/subfolders.

[timrodman]

Sorry, I just realized that the SSRS option in the video must be for when SSRS is actually the data source, not the consuming application.

[andre]

Yes, SSRS is one of the four currently supported data sources for Azure Data Catalog along with Analysis Services, SQL Server and Oracle databases.