Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Excel File: https://excelisfun.net/files/EMT1735.xlsx 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 workspace. 8. (02:22) Log into M365 Excel and use Organizational Data Types. 9. (02:47) Apply Data Type to see cards from the Single Source of Truth at Power BI Online. 10. (03:11) Comments?