- 4.8k
Introducing the RANK Window Function in DAX: An Overview and Example
Introducing the RANK Window Function in DAX: An Overview and Example Data Analysis Expressions (DAX) is a collection of functions, operators, and constants used in Microsoft's Power BI, Analysis ...
- 3.9k
Unveiling the Power of the New Card Visual in Power BI: Zebra BI Cards 1.6
In the world of data visualization and business intelligence, Microsoft Power BI continues to evolve and introduce powerful new features that enhance data reporting and analysis. One of the standout ...
- 4.4k
The Correspondence Between Excel Formulas and DAX Formulas: Why Financial Analysts Should Learn DAX
Excel, a widely used tool in the world of finance, has been the go-to platform for data analysis for decades. The formula-based structure of Excel allows analysts to manipulate, aggregate, and ...
- 5.4k
Assign Power BI Pro license to External (Guest) user
Buying a Power BI Pro license and assigning it to a user. A short guide on how to buy a Power BI Pro license and assign it to an external user. Step 1: Share the Power BI report first ...
- 34.8k
Enrich customer data with the postal code table
In a previous article we talked briefly about what you can do with the postal code table of the Netherlands. You can use a postal code table to fill in data on your website automatically. Enriching customer data ...
- 5.4k
Power BI Update September 2017
Power BI Update September 2017 The new Microsoft Power BI Desktop version has been released. This month brings another collection of new and useful updates, from reporting to data connectivity. The ...
- 6.5k
How much does Microsoft Power BI cost?
How much does Microsoft Power BI cost? Microsoft Power BI offers three enterprise pricing plans to choose from, one of which can be acquired for free (1 GB data capacity limit). Power BI – Free The ...
- 8.9k
Power BI Premium Embedded vs PRO vs FREE
At the moment, Microsoft has three versions of Power BI you can use. The Power BI Free, Power BI Pro and Power BI Premium. The Power BI Premium is a replacement of the Power BI Embedded version. This ...
- 6.5k
Free e-book: Introducing Microsoft Power BI
Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and ...
- 37.4k
Power BI Publish to the web
See how easy it is to add your reports to your public websites and blogs with Power BI Publish to web. Now you can craft your data story and tell it online in minutes. Here's how!
- 11.9k
Cool ASCII big text generator
I found this cool ascii text generator website today. You can use it to generate cool banners to use in your documentation or code comments.
- 7.4k
T-TSQL - Create 4 week Moving Total
This article will offer you a way to calculate a 4 week moving total in SQL using SQL Server. There are more ways to Rome but this is a way you can use to calculate it using a date dimension.
- 16.7k
Create a KPI box with an image / text overlap in SSRS
A common wish in SQL Server Reporting is to create an image with a text inside the image. When you are a common user of SSRS, you know this is not so easy. You cannot simply insert an image and a ...
- 23.1k
SSRS - Subscriptions in pending status
I had some subscriptions staying in the "Pending" LastStatus. It took me a lot of time to fix this problem. This blog will give you the solution for the problem.
- 11.7k
Prevent Divide by Zero in SSRS
In a previous post , I wrote about how to prevent the divide by zero issues in Reporting Services. The problem with the custom code I used was that the code returned the value 0 when one of the ...
- 49.1k
How to Refresh Reporting Services Cache?
I am working for a client which uses a Datawarehouse in which the data is loaded once a day during the night. During the rest of the day, nothing changes in the datawarehouse. After a couple of ...
- 4.7k
Powerpivot architecture
Today I came across a nice page on the Microsoft site about the architecture of Microsoft Powerpivot.
- 3.8k
SSRS2008R2 - Keep Header Visible While Scrolling
When you build a report in SSRS2008R2 and you want the top header to stay in place while you scroll down, you would normally expect the option "Keep header Visible While ...
- 4.1k
Wrong dot and comma in SSRS
In SSRS you can set in a cell how the value should be displayed. This can cause some problems if you do not know how to change certain settings. The dot and comma can be displayed ...
- 4k
SSRS Sparkline: NOW and TREND
The SSRS sparkline is a powerful little chart that shows a trend at a glance. Google Finance, for example, uses the sparkline to show the price of a share over the day, while ...
- 6.7k
SQL output in Excel shows millions
You will often want to copy the result of an SQL query to Excel and send it on, for example so someone can check the figures, or just as a simple list. You will then ...
- 5.1k
PowerPivot Format Percentage
In MS PowerPivot for Excel you can add your own calculations to your pivot table. A useful trick is to add the formatting you want straight into the formula. If you use a ...
- 3.7k
Tablix filter with the LIKE operator
The LIKE operator in Reporting Services works a little differently than in SQL. You would expect to use a %. Nothing could be further from the truth. So much for consistency.
- 3.7k
SSRS Best Practice II - Use Stored Procedures
I did some research on the internet into which source is better for a Reporting Services report. Below are the advantages of using Stored Procedures.
- 4.3k
Exporting more than 65,000 rows to Excel
From Report Manager you can export a report to Excel. But Excel 2003 can only handle 65,000 rows per sheet. With this little trick you can get around this problem easily.
- 3.9k
How do I back up my SSRS report as RDL
The question I asked myself today: how can I make a backup of a Reporting Services report that is already deployed on the Report Server?
- 3.7k
SSRS Best Practice I - Limit datasets
In SQL Server Reporting Services you can create datasets. One of the best practices is to keep these datasets to a minimum, preferably just 1. As soon as someone ever has to ...
- 3.7k
Subtotal Bold in a Matrix
As soon as you want to make the subtotals in a matrix bold or give them a different colour, you will notice that this does not work well. You cannot just make the word "Total" bold but will have to take one extra ...
- 4.1k
Backing up Reporting Services Data
All the data for the reports in your report manager is stored in the Reportserver database. So it is wise to make a backup of this database every day.
- 3.8k
The selected report is not ready for viewing
Lately I have often been annoyed by the following error message: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. ...
- 3.8k
Problems when exporting to Excel
When you make a report in Reporting Services, you often want to export it to Excel. Reporting Services quite often messes up the layout. For example, it often inserts columns ...
- 3.3k
Passing a multi-value parameter to a drillthrough report
This article describes how to pass a multi-value parameter from report A to report B the easy way. I fiddled around with it for a long time myself to get it working. The ...
- 5.5k
Divide by zero SSRS / division by 0 #error
Division by 0 is not allowed in Reporting Services/SQL Server. With this simple formula you can prevent division by 0, so the #Error message no longer appears in your report. This formula ...
- 3.3k
'Show All' in a parameter box
Say you want to use a parameter in your report with, for example, the names of the countries where you have customers. You will often want a choice in your ...
(34 rows affected)
Completion time: