Custom Data Types

%3CLINGO-SUB%20id%3D%22lingo-sub-1796055%22%20slang%3D%22en-US%22%3ECustom%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796055%22%20slang%3D%22en-US%22%3E%3CP%3EI%20really%20like%20the%20new%20Data%20Type%20concept%20for%20Geograhy%20and%20Stock%20data...%26nbsp%3B%20Is%20there%20a%20way%20to%20create%20custom%20Data%20Types%3F%26nbsp%3B%20This%20would%20be%20a%20very%20powerful%20way%20to%20make%20certain%20Enterprise%20data%20accessible%20to%20a%20broad%20audience%2C%20due%20to%20the%20simple%20syntax%20and%20ease%20of%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1796055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1796089%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Data%20Types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1796089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F836274%22%20target%3D%22_blank%22%3E%40Thomas_Meyer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThomas%2C%20with%20E3%2FE5%20you%20may%20create%20featured%20tables%20within%20Power%20BI%20environment%2C%20with%20them%20custom%20data%20types%20are%20available%20in%20Excel.%20Another%20option%20is%20in%20the%20latest%20Insiders%20builds%2C%20you%20may%20create%20custom%20data%20type%20by%20Power%20Query.%20At%20the%20moment%20an%20option%20is%20for%20beta%20insiders%2C%20you%20may%20check%20on%20Office%20insider%20site%2C%20somewhere%20in%20blogs.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I really like the new Data Type concept for Geograhy and Stock data...  Is there a way to create custom Data Types?  This would be a very powerful way to make certain Enterprise data accessible to a broad audience, due to the simple syntax and ease of use.

 

Thanks!

3 Replies
Highlighted

@Thomas_Meyer 

Thomas, with E3/E5 you may create featured tables within Power BI environment, with them custom data types are available in Excel. Another option is in the latest Insiders builds, you may create custom data type by Power Query. At the moment an option is for beta insiders, you may check on Office insider site, somewhere in blogs.

Highlighted

@Sergei Baklan NICE!!!  I was hoping something like that would be the case.   I'll take a look and see what I can work with; appreciate the explanation.

Highlighted

@Thomas_Meyer 

Good like with custom data types, that's interesting stuff. Not sure it'll be enterprise only option or for consumer/business subscription as well in a time, will see.