The ability to combine queries is powerful because it allows you to append or merge different tables or queries together. Why we need to Merge / Append queries? You can combine tables into a single table in the following circumstances: Too many tables exist, making it difficult to navigate an overly-complicated data model. You combineContinue reading “Merge & Append Queries”
Tag Archives: Power BI Desktop
Profile Data in Power BI
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”
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”
LR Virtual Classroom 