Power BI Theme Generator New Methods and Customizations
New methods and usage for themes were recently introduced for Power BI and in this article we cover how you can use these and customize them for Power BI.
2021-01-28
Power BI
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
16,209 reads
Power BI Merge Queries and Append Queries
In this tip we will cover how to use merge and append in Power BI to add additional data to a dataset that can then be used in reports and visuals
2021-01-22
Dynamic Power BI Slicer Using DAX Logic
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
2021-01-14
Analyze Azure Cosmos DB data using Synapse Link and Power BI
Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]
2021-01-12
2,480 reads
Manage Power BI Dataset with PowerShell
Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.
2020-11-30
Visualizing Azure Resource Metrics Data in Power BI
Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.
2020-11-23
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.
2024-01-16 (first published: 2020-10-14)
4,526 reads
Improve Power BI Performance with Horizontal Filtering
In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance
2020-10-07
Power BI Histogram Example using DAX
Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark
2020-09-16
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