What is data profiling? Why do we need to perform in Power BI. Yes, Data Profiling is a crucial part of data warehousing, data migration, and Business Intelligence projects. •You have to make sure the data which you are loading to the destination is in a good quality. •During the process of data profiling, mainlyContinue reading “Profile Data in Power BI”
Category Archives: Power BI
Clean and Transform data with Power BI Query
In this section 10, we are going to learn about the Cleaning & Transforming the data with Power BI Query || Automate Data Tasks in Power Query Editor. Why Do We Need To Clean / Transform The Data Live Demo Of Transforming The Data Best Practices For Naming Tables, Columns, And Values Evaluate And ChangeContinue reading “Clean and Transform data with Power BI Query”
Query Folding and Query Diagnostics in Power BI
It is important that your Power BI dashboard is updated and refreshed as quickly and giving good performance to your dashboard users. Having query timeout error, more refreshing time is going to cause frustration to the users. Power BI has in built tools to check the performance of your queries. Power BI provides the PerformanceContinue reading “Query Folding and Query Diagnostics in Power BI”
5 Common Data Import Errors in Power BI
In this post, we are going to see about the below topics in detail in the live demo video. •Various Reasons For Data Import Errors in Power BI •Error – 1 Query Timeout Expired – Causes & Resolution •Error – 2 We Couldn’t Find Any Data Formatted As A Table •Error – 3 Could NotContinue reading “5 Common Data Import Errors in Power BI”
Import vs Direct Query vs Live Connect
Check the demo video for the detailed live explanation. Selection of a Storage Mode: The three different types of storage modes you can choose from: 1.Import – Import mode is the default while importing your data 2.Direct Query- you are creating a direct connection to the data source. Instead of slowing down performance by having toContinue reading “Import vs Direct Query vs Live Connect”
How to Get data in Power BI Desktop
I have briefly described the below topics in the video. 1.Sources Of Data 2.Real Time Demo In Power BI •Get Data From Files •Get Data From Relational Data Sources •Get Webpage Data By Providing Examples •Get Data From Online Services 3.Connect To On-premises Data Sources With A Power BI Gateway 4.Change Data Source Settings
What is Power BI Desktop
Most Power BI report designers who work on business intelligence projects use Power BI Desktop to create Power BI reports, and then use the Power BI service to collaborate and distribute their reports. How to Install Power BI Desktop – 3 ways: Download from Microsoft Store – Link Here Download from Microsoft Website – Link here Download from PowerContinue reading “What is Power BI Desktop”
Power BI Report Server – On Premises Data
What is Power BI Report Server: As per Microsoft Website, Power BI Report Server is the on-premises solution for reporting today, with the flexibility to move to the cloud tomorrow. It’s included with Power BI Premium so you have the ability to move to the cloud on your terms. Report Server gives your users access to rich,Continue reading “Power BI Report Server – On Premises Data”
All about Power BI Service
As you know Power BI is a collection of software services, apps that work together to help you create, share dashboards. The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is the SaaS (Software as a Service) part of Power BI. In the Power BI service, dashboards help you keep a finger on the pulse ofContinue reading “All about Power BI Service”
Get Started with Power BI — Everything you need to know in 6 steps
As beginner, you need to know the very important concepts in Power BI ( not here to tell you the definition of the Power BI:) ) Step 1: There are three important components in power BI: 1.Microsoft Windows desktop application called Power BI Desktop 2.an online SaaS (Software as a Service) called the Power BI Service 3.MobileContinue reading “Get Started with Power BI — Everything you need to know in 6 steps”
LR Virtual Classroom 