Refresh a Power BI Dataset using Microsoft Power Automate
Learn how to refresh a Power BI dataset by integrating Power Automate into the report.
2022-11-18
Power BI
Tutorial to Create a Power BI Report Using PostgreSQL
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
3,045 reads
MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
1,576 reads
Stairway to DAX and Power BI - Level 18: Time Intelligence Dates Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces five DAX Time Intelligence functions related to Dates: DATESBETWEEN(), DATESINPERIOD(), DATESMTD(), DATESQTD(), and DATESYTD(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the functions in Power BI.
2022-11-23 (first published: 2022-11-02)
1,025 reads
Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.
2022-11-23 (first published: 2020-10-14)
3,825 reads
Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.
2022-11-23 (first published: 2020-09-02)
2,896 reads
Create Power BI Connection to Azure SQL Database
Learn how to use Power BI to retrieve data from an Azure SQL Database.
2019-03-15
2,461 reads
The BI Journey: The Expert’s Advice – Part 1
Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is spent on the underlying model, it won't be adaptable enough to grow. In this article by Gogula Aryalingam, you'll see how the advice of a mentor helped a newbie understand how to create a flexible model that will lead to a valuable BI solution.
2019-03-11
2,975 reads
Getting Started with Power BI - Part 1
In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.
2019-03-01
5,579 reads
Visualise SQL Server IO Stats
Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.
2020-08-07 (first published: 2018-12-18)
5,871 reads
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC