Organizational Data Types in Excel M365 & Power BI. Excel Magic Trick 1735

About this tutorial:

Video duration: 00:03:27
Download Excel File:
Learn how to use Organizational Data Type in Excel to lookup records from an Power BI Online source.
1. (00:00) Introduction to how an Organizational Data Type works.
2. (00:50) Trick requires Microsoft 365 Excel, Power BI Desktop and Power BI Online.
3. (01:07) Source Table in Excel.
4. (01:13) Import Table into Power BI Desktop.
5. (01:34) In Model View apply “Is Featured Table” option to convert table to a Data Type that Power BI Online and Excel 365 can interpret.
6. (02:00) Publish to Power BI Online.
7. (02:16) Select…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads