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
17,057 reads
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
This article focuses on the use of OData Queries to integrate DevOps Analytics data to Power BI.
2021-01-21
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
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
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
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,889 reads
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
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
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.
2024-01-16 (first published: 2020-09-02)
3,679 reads
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
It can be tedious to check what visual interactions have been configured in a...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item The Last Good DBCC Run
Hi everyone I have a SP that finds the average based on 3 tables. ...
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers