Understanding Power BI Row-Level Security (RLS) for Data Protection
Row-Level Security in Power BI is a feature that restricts the data a specific user can see within a report or dashboard. Rather than building separate reports for different audiences, RLS allows a single report to show different data to different people based on who is signed in. A regional sales manager, for example, might… Read More
Mastering Power BI Custom Visuals: Custom Calendar by Akvelon
Unlock the power of visual date analysis with the Custom Calendar by Akvelon in Power BI. This calendar visual enables you to display multiple data metrics within each day of a monthly calendar view, providing a comprehensive snapshot of your data over time. Unlock Powerful Data Insights with the Custom Calendar Visual by Akvelon In… Read More
Ensuring Secure Data Sharing in Power BI
As more enterprises adopt Power BI, data security remains a top concern. Business Intelligence Architect Steve Hughes recently discussed essential security and compliance tools in Power BI—such as data classification, privacy settings, encryption, and the enterprise data gateway. This blog series, reflecting Power BI as of April 2017, addresses key questions about these topics. (Note:… Read More
Copilot in OneNote: Transform Your Digital Note-Taking Experience
Discover the future of digital organization with Copilot in OneNote, an immersive new course led by Devin Knight, President. This preview introduces a hands-on learning experience designed to elevate productivity, streamline task management, and unleash creativity using Microsoft’s powerful AI tool—Copilot—integrated directly into OneNote. Unlocking Copilot in OneNote: A Revolutionary Note-Taking Journey The integration of… Read More
Exploring Power BI Custom Visuals: Card Browser Overview
Discover how to enhance your Power BI reports using the Card Browser custom visual. This powerful visual enables you to showcase document data with stunning images, creating an engaging and interactive browsing experience. Comprehensive Guide to Module 77 – Power BI Card Browser Visual As data storytelling evolves, the demand for visually immersive and interactive… Read More
Power BI Custom Visuals: How to Use the Scroller Visual for Dynamic Reporting
In this tutorial, you’ll discover how to enhance your Power BI reports using the Scroller custom visual. Developed to mimic the look and feel of a real-time stock ticker, the Scroller is ideal for showcasing continuously updating metrics such as stock prices, sales figures, and deviation values in a sleek, animated format. Introduction to Scroller… Read More
Are Professional Certifications a Scam or Truly Worth the Investment?
In today’s competitive job market, many professionals question the value of certifications. Are they simply a money-making scheme, or do they actually lead to career growth and real-world success? In this insightful video from Greg Trzeciak explores the true worth of professional certifications, featuring expert insights from HR leader Megan Richardson and testimonials from successful… Read More
Power Query: Using User-Driven Parameters to Control M Query Functions
Have you ever had users pull massive datasets from your database only to immediately filter down to a small subset in Excel? This inefficient process wastes bandwidth and slows performance, especially when dealing with large tables. Power Query offers a dynamic solution by allowing you to create queries that filter data based on user-supplied parameters—so… Read More
Mastering Excel 2013 for Business Intelligence: How to Optimize Your Slicers
Welcome back to the Excel at Excel blog series with Steve Hughes! In his previous post, Steve demonstrated how to add slicers to your Excel worksheets. In this article, we’ll focus on how to clean up and customize slicers to enhance user experience and improve your BI dashboards. The Importance of Refining Slicers for Optimal… Read More
How to Download Emails and Attachments Using SSIS
Have you ever needed to download emails and their attachments directly through SQL Server Integration Services (SSIS)? If so, you’ve come to the right place. Task Factory, a powerful suite of custom SSIS components developed by offers an Email Source component that enables you to extract email content directly into your SSIS data flow. This… Read More
Understanding PowerApps Canvas vs. Model-Driven Applications: Key Differences Explained
Are you familiar with the distinctions between PowerApps Canvas and Model-driven applications? Whether you’re a seasoned PowerApps user or just starting out, understanding these two app types is crucial for selecting the right approach for your project. In this article, Brian Knight breaks down the differences and helps you decide when to build a canvas… Read More
Exploring Power BI Embedded in Azure: What You Need to Know
In a previous discussion, I covered two methods to embed Power BI into your applications or websites via Azure and Office platforms. Today, I’m focusing on Power BI Embedded specifically within Azure and what makes this solution distinct and advantageous. Comprehensive Guide to Deploying Power BI Embedded through Azure Power BI Embedded is a powerful… Read More
Understanding PowerApps Canvas vs. Model-Driven Applications: Key Differences Explained
Are you familiar with the distinctions between PowerApps Canvas and Model-driven applications? Whether you’re a seasoned PowerApps user or just starting out, understanding these two app types is crucial for selecting the right approach for your project. In this article, Brian Knight breaks down the differences and helps you decide when to build a canvas… Read More
Mastering the PL-300 Certification Exam: Understanding Merging vs. Appending Queries in Power BI
Welcome back to our ongoing PL-300 Power BI certification exam prep series brought to you. In this installment, Angelica Domenech focuses on the critical “Prepare the Data” functional area, which is a key part of the Microsoft Power BI Data Analyst Associate certification. If you haven’t yet, make sure to check out the first episode… Read More
Comprehensive Guide to Data Discovery and Classification with SQL Server 2019
Are you interested in mastering data discovery and classification using SQL Server 2019? In a recent webinar, Steve Hughes, Director of Consulting provides an in-depth tutorial on how to perform data discovery and audit sensitive information within your SQL Server databases effectively. The Strategic Value of Data Classification and Security in SQL Server 2019 In… Read More