Relationships are defined between tables through primary and foreign keys. This is the important part of data modeling. As soon as you import the data, one of the major step is to define the relationship between the tables to further perform calculations & analysis. Relationships between tables are formed when you have primary and foreignContinue reading “6 Types of Joins in Power BI”
Category Archives: Power BI
Merge & Append Queries
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”
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”
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”