Channel: MrExcel.com

Category: Howto & Style

Tags: mrexcelpower query custom data typespower bi custom data typeslinked data types in excelmicrosoft excelbill jelenexcelhow to enable power bi table as linked data type in excelexcel data typescustom linked data type from power bicustom data typesmark table as featured in power bioffice 365

Description: The data types gallery with Geography, Stocks, Currency, and Wolfram is mildly interesting. But I think the real goal is to get your own company data in the Data Type. I want it to be a very rich experience, just like Wolfram Data Types: 1) Type plain text and convert to a data type 2) From the card for the data type, return an array of entities (such as all the people in Bob Marley and the Wailers music act. 3) Have those fields returned from the Data Card be Data Types as well, so you can drill down and get more information about the sub-entity 4) The data type should be able to return an image from an Image URL 5) The data type should be able to return a clickable hyperlink. 6) It would be nice if the little icon for the data type was customizable. Bill's theory is that once you can get to your own company data in data types, no one will ever download data from Wikipedia again. Table of Contents (0:00) Introduction (1:29) My vision for the future of data types (2:16) Building a data type in Power BI (5:27) Mark the tables as Featured (6:54) Test the custom data type in Excel