Author: Annie D

Effortlessly Sync Your Projects to GitHub with This Powerful Tool!

Posted on by Annie D

***** Video Details *****
Managing your code has never been easier! Lovable streamlines best-practice coding and now automates GitHub repository creation—no more manual setup. Traditionally, you’d have to handle pull and push requests manually, but Lovable gets you started instantly.

If you’re serious about development, having a GitHub account is non-negotiable—it’s your central hub for all projects. Haven’t set one up yet? Now’s the time!

***** Related Links *****
https://lovable.dev/
https://github.com/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – <a Continue reading “Effortlessly Sync Your Projects to GitHub with This Powerful Tool!” →

PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1879.xlsx
Learn about the automatic number formatting that a PivotTable applies to calculations based on the source data number formatting
Topics:
1. (00:00) Introduction.
2. (00:12) PivotTable with Automatic Number Formatting
3. (01:16) Closing

#excel #microsoft #excelisfun #excelcourse #pivottable #pivot_table #pivots

🔴 Microsoft Power BI / Fabric Q&A – LIVE (March 15, 2025) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI & Microsoft Fabric! Get your questions in the chat early as we don’t get to all of them.

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want Continue reading “🔴 Microsoft Power BI / Fabric Q&A – LIVE (March 15, 2025) (Member Chat 2nd Half)” →

Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1878.xlsx
See that the Data Validation List feature removes duplicates up to 33,000 rows. After that, we must do old school methods: SORT and UNIQUE functions, or even older school methods from the 2012 Ctrl Shift Enter Mastering Excel Array Formulas Book.
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction
2. (00:03) New Ability of Data Validation List to Remove Duplicates
3. (01:06) Example of New Feature When It Does Not Work Poast Rows 33,000
4. (01:27) Old Fashion Way to Overcome New Feature Limited Row Ability
5. (02:20) Summary
6. (02:29) Closing

#excel #microsoft #excelisfun #excelcourse #datavalidation #excelfail

Connection woes using Power BI Direct Lake and an App???

Posted on by Annie D

Stop the hassle of interrupted connections in Power BI when using Direct Lake. Marthe guides you through setting up a fixed identity so your published apps can be leveraged without giving direct access to OneLake.

Specify a fixed identity for a Direct Lake semantic model
https://learn.microsoft.com/fabric/fundamentals/direct-lake-fixed-identity

Setting up RLS on a Direct Lake semantic model
https://www.datazoe.blog/post/setting-up-rls-on-a-direct-lake-semantic-model

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— <a href="http://twitter.com/guyinacube" target="_blank" Continue reading “Connection woes using Power BI Direct Lake and an App???” →

This No-Code Tool Builds Apps in HOURS! (You Won’t Believe How Easy It Is!)

Posted on by Annie D

***** Video Details *****
Experience No-Code Web Development With Lovable.

***** Related Links *****
https://lovable.dev/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – https://mentor.enterprisedna.co/
EDNA Chat – https://mentor.enterprisedna.co/chat
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing

Now’s the Moment: Move from Power BI Premium to Microsoft Fabric

Posted on by Annie D

Ready to unlock new possibilities in your analytics journey? Adam talks about how to migrate your capacity from P SKU to F SKU and some things to be aware of. If you still just want to use Power BI only, you still can!

Important update coming to Power BI Premium licensing
https://powerbi.microsoft.com/en-us/blog/important-update-coming-to-power-bi-premium-licensing/

Microsoft Fabric Pricing Page
https://azure.microsoft.com/pricing/details/microsoft-fabric/

Microsoft Fabric Features by SKU type
https://learn.microsoft.com/fabric/enterprise/fabric-features

Automate your migration to Microsoft Fabric capacities
https://www.microsoft.com/microsoft-fabric/blog/2024/12/02/automate-your-migration-to-microsoft-fabric-capacities/
https://github.com/microsoft/semantic-link-labs/blob/main/notebooks/Capacity%20Migration.ipynb

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training Continue reading “Now’s the Moment: Move from Power BI Premium to Microsoft Fabric” →

Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelShort69-71.xlsx

See the old method of Excel worksheet formulas and the New, easier, Microsoft Excel 365 worksheet formulas.
#excel #365excel #excel365 #spredsheet #visicalc #lotus #lotus123

Excel Pivot Table Number Format Copied From Source Data Episode 2674

Posted on by Annie D

🚀 *Unbelievable Excel Update!* 🚀

Pivot Table numeric formatting is now automatically coming from the grid! 🎉 Microsoft didn’t announce this (that I’ve seen), but it just *worked* this morning. No more manually formatting numbers in your Pivot Tables—Excel is pulling it straight from the source data.

✅ Thousands separator? ✔️
✅ Currency symbols? ✔️
✅ No extra steps? ✔️

Watch as I demo this game-changing update with a quick dataset. This small but mighty improvement is a *huge* win for efficiency!

💡 Have you seen this in your version of Excel yet? Let Continue reading “Excel Pivot Table Number Format Copied From Source Data Episode 2674” →

How to Build Valuable Web Apps in Less Than a Day

Posted on by Annie D

***** Video Details *****
The rapid evolution of AI-driven app development is unlocking unprecedented opportunities for business and innovation. In this discussion, Sam introduces LearnFlow, a prototype application built in just a few hours using Lovable.dev—without writing any code. The app automates the creation of structured learning materials by integrating AI models via API calls, demonstrating the efficiency and scalability of no-code development. The conversation also explores how AI-powered tools like Windsurf and Cursor allow developers to iterate and enhance applications rapidly. The potential for integrating audio AI, automation, and multimodal AI models suggests a new frontier in software creation where Continue reading “How to Build Valuable Web Apps in Less Than a Day” →