Power BI Desktop

Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6

• by Additional Articles

• SimpleTalk

• Power BI

• Article

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

Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3

• by Additional Articles

• SimpleTalk

• Power BI

• Article

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

Analyze entity data flow in Power BI Desktop using Sankey charts

• by Additional Articles

• MSSQLTips.com

• Power BI Desktop

• Article

Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.

2018-04-05

3,082 reads

Correlation Analysis using Correlation Plot in Power BI Desktop

• by Additional Articles

• MSSQLTips.com

• Power BI

• Article

Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance.

2017-12-06

2,780 reads

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

• by Bill Pearson

• SQLServerCentral.com

• Stairway Step

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

You rated this post out of 5. Change rating

2022-04-04 (first published: 2017-11-29)

4,697 reads

• Discuss

Using Power BI Desktop to Visualize SQL Server Metadata

• by Additional Articles

• SimpleTalk

• Power BI Desktop

• Article

You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.

2017-01-16

3,767 reads

Importing Excel Data into Power BI Desktop

• by Additional Articles

• SimpleTalk

• Power BI Desktop

• Article

In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we'd probably need the other analysis components such as the Power Pivot tables, Power View visualizations, Power Query queries. It is all possible, and Robert Sheldon demonstrates how.

2016-12-28

2,896 reads

Using R Machine Learning Script as a Power BI Desktop Data Source

• by Additional Articles

• SimpleTalk

• R Language

• Article

You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple example that shows how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.

2016-02-15

4,931 reads

Splitting Tables

• by daveangel

• SimpleTalk

• Topic

Hi folks,I am in some desperate need of a T-SQL expert....I am trying to split a large table of 147,000 records in SQL server into 147 x 1,000 csv files.  Is this easy to do?  I am at the end of my tether with DTS and was hoping for a solution in T-SQL.  Can anyone […]

2005-04-21

RE: Printing Reports from RS

• by Jonathan Spink

• SimpleTalk

• Reply

Yes, you're right, though you can write your own print rendering extension (apparently). Other than that use the PDF export. The version coming with SQL Server 2005 may well have one-click printing as a feature; the current version was added as something of an afterthought. Some features are of course interactive (document maps, drill-down and […]

2005-04-13