Skip to content
Chris Koester

Data Analytics Consultant in Indianapolis, Indiana

Primary Navigation Menu

Menu
  • Home
  • About
  • Contact

Power BI

Push Performance Counter Data into a Power BI Streaming Dataset

Push Performance Counter Data into a Power BI Streaming Dataset

2017-12-27
By: Chris Koester
On: 2017-12-27
In: Power BI, SSAS Tabular
With: 0 Comments

In the previous post I showed how you can Push Data into Power BI Streaming Datasets with C#. That example used dummy data. In this post I’ll show how to push performance counter data into a Power BI Streaming Dataset as a real world example. This scenario allows for monitoring a computer or application in near real time in the browser. I won’t go through the steps of creating a Power BI Streaming Dataset. You can reference my previous post if you need instructions. I will note that the value names that you choose in the Streaming Dataset must match the C# property names for theRead More →

Power BI Streaming Datasets with C#

Push Data into Power BI Streaming Datasets with C#

2017-11-05
By: Chris Koester
On: 2017-11-05
In: Power BI
With: 0 Comments

This post will demonstrate how to push data into Power BI Streaming Datasets with C#. For demo purposes I normally use LINQPad to run the code, but you could also create a .Net or .Net Core console application. LINQPad is an excellent, lightweight scratchpad for C# and other .Net languages. Power BI Streaming Datasets are a very cool feature because dashboard tiles that use them update in real time. You don’t have to refresh the browser window to display new data. With this feature you can watch your data in near real-time. This could be compelling in scenarios involving sensors, IoT, website traffic, etc. Here isRead More →

Call an Azure Function from Power BI

Call an Azure Function from Power BI

2017-03-28
By: Chris Koester
On: 2017-03-28
In: Data Integration, Power BI, Power Query
With: 0 Comments

This post shows how to call an Azure Function from Power BI. This scenario offers some interesting possibilities, because it allows for integrating the power of several common programming languages with Power BI and Power Query. If you’re not familiar with Azure Functions, it’s a service that allows you to run small pieces of code without having to deal with a server. In this example, we’ll write a query in Power BI that submits a time zone to an Azure Function. The function simply returns the current time in the specified time zone. While this is a very basic example, it is important because itRead More →

Twitter status update from Power Query

Post to Twitter from Power Query

2016-07-15
By: Chris Koester
On: 2016-07-15
In: Data Integration, Power Query
With: 2 Comments

You might be surprised to learn that you can post to twitter from Power Query. After all, the primary use for Power Query is obtaining and transforming data. While this is true, Power Query also offers the ability to perform an HTTP POST, which means that we can submit data via the web. My first blog post titled “Get Data from Twitter API with Power Query” involved an HTTP POST in order to obtain a token from the Twitter API. In this post I’ll show how you can Tweet from Power Query with some help from Temboo. So what is Temboo? Temboo is a service that allows usRead More →

Follow Me

  • Twitter

Topics

Analysis Services API Azure Azure Functions C# code CSV Data integration DAX duplicates Excel JSON M MDX OAuth OPENJSON Parameters Power BI Power Map Power Pivot Power Query PowerShell REGEX Reporting Services REST SQL Server SSAS SSAS Tabular SSIS SSRS Stored Procedure Streaming Temboo text TMSL Twitter usgs VB xml

Certifications

MCSA: SQL 2016 Business Intelligence Development

Recent Posts

  • Retrieve JSON Data from SQL Server using a Stored Procedure and C#
  • Load JSON into SQL Server Using a Stored Procedure and C#
  • Push Performance Counter Data into a Power BI Streaming Dataset
  • Push Data into Power BI Streaming Datasets with C#
  • Optimized Multi-value DAX Parameters in SSRS

Categories

  • Data Integration
  • Power BI
  • Power Query
  • PowerShell
  • Reporting Services
  • SSAS Tabular

Archives

  • March 2018
  • December 2017
  • November 2017
  • October 2017
  • August 2017
  • June 2017
  • March 2017
  • January 2017
  • December 2016
  • July 2016
  • May 2016
  • April 2016
  • December 2015
  • July 2015
  • February 2015
  • August 2014

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Designed using Responsive Brix WordPress Theme. Powered by WordPress.