I've seen multiple examples in the internet where the new streaming dataset is used. All the examples have three options for the data source (see picture):APIStream AnalyticsPUBNUB Unfortunately my PowerBI provides only "API" and "PUBNUB". What can I do to activate Stream Analytics?

Hi tgs, There are only two options for the data source on my side, you can check the following screenshot. Moreover, as stated in this official article, there are two ways to create a real-time streaming data feed that can be consumed and visualized by Power BI. And only API and PubNub data sources appear in the screenshot of the official article.• Power BI REST API using a real-time streaming endpoint• PubNub If you want to output Real-Time Azure Stream Analytics data to a Power BI Dashboard, you can follow the steps in this article. Thanks, Lydia Zhang

I saw the following articles. In both I can find SA as Data Source.http://radacad.com/monitor-real-time-data-with-power-bi-dashboardshttps://community.dynamics.com/nav/b/technicaltipsandtricksfordynamicsnav/archive/2016/08/11/real-time-dashboard-tile-amp-streaming-dataset-in-power-bi

Hi tgs,As mentioned in the second blog you have posted, streaming data sets can be now either API, Azure Stream Analytics (coming soon), and PubNub. The option for Azure Stream Analytics is not released yet. We would need to wait some time to use it.Currently, you can create a real-time dashboard for Azure Stream Analytics following the steps in this blog:http://radacad.com/stream-analytics-and-power-bi-join-forces-to-real-time-dashboard .Thanks,Lydia Zhang

To build onto Lydia's answer: We are currently working on having a feature to enable ASA to output to Power BI via streaming datasets. This will in turn allow you to create streaming tiles based on ASA outputs. Later this year, we plan to have a private preview for this feature. If you're interested, please PM me, and I'll add you to our private preview list. Thanks!-Sirui

I am also interested in creating live dashboards on Power BI, using streaming data from ASA (if possible, I would like to be notified of the private preview as well). In the meantime, I have set up a streaming analytics service as outlined in the two links mentioned previously: 1 - https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-power-bi-dashboard/2 - http://radacad.com/stream-analytics-and-power-bi-join-forces-to-real-time-dashboard Everything is working as expected - I am sucessfully streaming data (JSON) from my event hub to Power BI. The only problem is that the numerical values in the data are being interpreted as a string type; therefore I cannot get any of the graph visualizations to work correctly. I had the same problem when using Power BI Desktop (with data being imported from Azure table storage), however, that application allowed me to "shape" the data, and modify the data types if necessary. I simply changed the type from a string to a decimal and everything worked correctly (of course the desktop application can only create "snapshot" reports, and not real time or "live" charts). Is there a way I can change the data type using the Power BI web application? There could be an issue with my ASA Query but the data is being transferred... Select timecreated,Out,Ex,Rm,Namefrom devicesinput TIMESTAMP by timecreated Thanks in advance. sirui_sun wrote:To build onto Lydia's answer: We are currently working on having a feature to enable ASA to output to Power BI via streaming datasets. This will in turn allow you to create streaming tiles based on ASA outputs. Later this year, we plan to have a private preview for this feature. If you're interested, please PM me, and I'll add you to our private preview list. Thanks!-Siruiof the following links

stream analytics as streaming dataset source

11 Replies

Anonymous
Not applicable
9 years ago
Hi tgs,

There are only two options for the data source on my side, you can check the following screenshot.

Moreover, as stated in this official article, there are two ways to create a real-time streaming data feed that can be consumed and visualized by Power BI. And only API and PubNub data sources appear in the screenshot of the official article.

• Power BI REST API using a real-time streaming endpoint
• PubNub

If you want to output Real-Time Azure Stream Analytics data to a Power BI Dashboard, you can follow the steps in this article.

Thanks,
Lydia Zhang
- tgs
  New Member
  9 years ago
  I saw the following articles. In both I can find SA as Data Source.
  http://radacad.com/monitor-real-time-data-with-power-bi-dashboards
  https://community.dynamics.com/nav/b/technicaltipsandtricksfordynamicsnav/archive/2016/08/11/real-time-dashboard-tile-amp-streaming-dataset-in-power-bi
  - Anonymous
    Not applicable
    9 years ago
    Hi tgs,
    
    As mentioned in the second blog you have posted, streaming data sets can be now either API, Azure Stream Analytics (coming soon), and PubNub. The option for Azure Stream Analytics is not released yet. We would need to wait some time to use it.
    
    Currently, you can create a real-time dashboard for Azure Stream Analytics following the steps in this blog:http://radacad.com/stream-analytics-and-power-bi-join-forces-to-real-time-dashboard .
    
    Thanks,
    Lydia Zhang

Forum Discussion

stream analytics as streaming dataset source

11 Replies

Related content

Streaming Datasets

onelake for streaming datasets

Streaming dataset

Streaming Dataset

Streaming Dataset Failure