Summary
Keywords
Full Transcript
🔥 Join our popular FREE Power BI beginners course today 👉 https://link.xelplus.com/yt-g-custom-powerbi-starter 🛑 IMPORTANT UPDATE (2026): Microsoft retired Organization Data Types in Excel on July 31, 2025. The Excel-side workflow shown in this video no longer works. Existing workbooks can no longer refresh. The replacement is Data → Get Data → From Power BI, which connects Excel to a Power BI semantic model as a live PivotTable or table. 📖 Full updated tutorial with the modern workflow + migration steps for old workbooks: https://www.xelplus.com/excel-organizational-data-types/ What's still useful in this video: the Power BI Desktop steps (creating a Featured Table, setting Row Label and Key Column, publishing to a workspace) are unchanged in 2026. Skip ahead to those sections if you're setting up a semantic model for Excel users to consume the new way. ⭐ Ready to become a Power BI Pro? Join our "Fast Track with Power BI" course 👉 https://www.xelplus.com/course/fast-track-to-power-bi/ Join 500,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 00:00 The "Single Source of Truth" benefit for organizational data 00:37 Access Rights Needed 01:15 How to Use Organization Data Types 04:16 Convert Data into Data Types 05:55 How to Create Organization Data Types 10:00 How to Manage Permissions 11:46 Wrap Up 🎬 LINKS to related videos: - Get Started with Power BI: https://youtu.be/c7LrqSxjJQQ - 10 Power BI Tips for Better Dashboards: https://youtu.be/mYpOSfqgTvY ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel #powerbi
