Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Custom Data Types From Power BI – 2450

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.