Category: Business

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

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” →

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” →

Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/ExcelShort68.xlsx

Learn how to randomize numbers with a normal distribution using NORM.INV function or use the RANDBETWEEN or RANDARRAY functions to randomize numbers across a uniform distribution.

#excel #excelfunctions #microsoft #excelisfun #data #randomize

The AI Revolution: How Automation, APIs, & No-Code Tools Are Changing Everything with Brian Julius

Posted on by Annie D

***** Video Details *****
This conversation explores the transformative power of AI-driven tools in development, data analytics, and automation, highlighting how new technologies are reshaping workflows and unlocking new opportunities. Sam and Brian discuss the rise of API-driven models, which are making analytics and software development more accessible than ever, allowing users to build applications, automate processes, and analyze data—all with natural language inputs. They challenge the fear-driven narrative that AI will replace jobs, instead arguing that AI is democratizing technology, making software development faster, easier, and more cost-effective while also creating more opportunities in tech, automation, and entrepreneurship.

***** Related Links Continue reading “The AI Revolution: How Automation, APIs, & No-Code Tools Are Changing Everything with Brian Julius” →

PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1877.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the PIVOTBY & LAMBDA Functions. This solution deals with duplicate values.
This trick comes from ExcelLambda at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:24) PIVOTBY & LAMBDA Functions Solution. See COUNTA and IF Functions and the @ implicit intersection operator.
3. (01:55) Summary
4. (02:04) Closing
#excel #microsoft #excelisfun #excelcourse #groupby #pivotby #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata #lambda

Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1876.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the PIVOTBY & SINGLE Functions. This trick comes from viktorasgolubevas at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:25) PIVOTBY & SINGLE Functions Solution.
3. (01:48) Summary
4. (02:23) Closing

#excel #microsoft #excelisfun #excelcourse
#groupby #pivotby #single #singlemom #singlelife #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata