SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
2018-12-17
3,047 reads
In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as the host software (all of the formulae shown would work equally well in PowerPivot or SSAS Tabular). This article is designed to be the first in a series of articles which will show you how to master programming in DAX.
2018-11-22
2,396 reads
Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.
2018-10-08
3,198 reads
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
2018-08-20
2,844 reads
Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.
2018-07-30
3,913 reads
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
2018-07-19
3,727 reads
R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.
2018-07-02
2,546 reads
Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads and the tools that best support each workload.
2018-06-29
3,416 reads
In this tip, you will be walked through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.
2018-06-28
3,361 reads
Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks you through importing and manipulating data with the Query Editor in Power BI Desktop.
2018-06-25
3,270 reads
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
With the PBIR format of Power BI reports, it’s much easier to make report...
By Steve Jones
As we close out the year, I decided to drop this post here and...
Comments posted to this topic are about the item The Oldest Article
Comments posted to this topic are about the item Happy New Year 2025
How does this capture multiple values from a cursor, and put them into an...
What's the oldest article on SQL Server Central (take a guess)?
See possible answers