Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-21
Power BI
Power BI Incremental Refresh for SQL Sources
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-20
Business Reasons For Implementing Power BI
Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc. Each data extract or report is created by a BI or DB Development Team member. Often […]
2020-07-07
7,098 reads
Create Custom Functions in Power Query
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
2020-04-21
39,334 reads
Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
8,271 reads
Fetch Web Data in Power BI
Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]
2020-03-17
5,297 reads
Using the RANKX function in Power BI
Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]
2020-03-12
18,643 reads
Power BI Advanced Q&A
What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?
2020-01-31
Month-over-Month calculation using DAX in Power BI
Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]
2020-01-27
74,868 reads
Synchronously Refreshing a Power BI Dataset using Azure Logic Apps
In this tip we will implement a polling mechanism to verify if the Power BI dataset has refreshed successfully.
2019-12-25
Blogs
A New Word: Apolytus
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
Tired of Tedious SQL Queries? AI Tools Can Automate The Boring Parts
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
Forums
Table Partitioning - remove null range
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Principal owns a service?
This is one I haven't seen before. I'm trying to drop a database user...
Issues backing up Analysis Services databases - silent failures
I have a PowerShell script that I use to automate the backup of Analysis...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers