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”
Tag Archives: 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”
Download Power BI E-Books (Free)
The COVID pandemic has paved way for self learning and its important that you take the right steps when you learn something new. Else eventually, you will lose interest or feel difficult. As Power BI is little complex yet simple UI, I would suggest start learning by reading with the book. The book will helpContinue reading “Download Power BI E-Books (Free)”
DA-100 Exam Preparation Guide & Checklist
Exam DA-100: Analyzing Data with Microsoft Power BI Microsoft has given comprehensive list of guide on DA-100 exam. The questions are broadly covered from the below sections. The key journey is learning the difference between Creating Reports Creating Models The best way to learn POWER-BI is learn by doing Learn – Do – Fail –Continue reading “DA-100 Exam Preparation Guide & Checklist”
LR Virtual Classroom 