Why you should avoid Implicit Measures in your Power BI model
Learn about the differences and challenges with implicit and explicit measures in Power BI.
2025-02-05 (first published: 2025-01-06)
3,941 reads
Learn about the differences and challenges with implicit and explicit measures in Power BI.
2025-02-05 (first published: 2025-01-06)
3,941 reads
In this article, we develop the Power BI DAX formula for basket analysis. It is the technique used in retail industry for market based analysis.
2024-05-10
1,716 reads
In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.
2024-04-19
2,298 reads
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
2024-03-11 (first published: 2024-03-08)
1,270 reads
In this tip, we explore two behaviors for the DAX RANKX function that can lead to incorrect results and discuss workarounds and fixes.
2023-07-24
In this article, learn how to set up and use Microsoft Data Gateway to connect data sources from various locations such as cloud or on-premises.
2023-07-17
Power BI and Azure are two related services, but with a considerable independence between them. Power BI share the Azure Tenant for security management, but in relation to networking, they are in completely different environments.
2023-07-12
Microsoft Power BI is an interactive data visualization tool primarily designed with business intelligence in mind. Apart from being a visualization tool, it also has some built-in security features that we will discuss in this article.
2023-06-30
This article will cover how to create multiple relationships between the same tables in Power BI to build the data model you need.
2023-06-12
Learn how you can use Power BI to forecase the future trends of data.
2023-02-27
47,586 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers