Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
fredsnertz
New Member

Streaming Datasets

I am very new to Power BI and I have some questions about Streaming Datasets in the Service:

* Is a Streaming Dataset the only way to send data to the Power BI Service using the APIs?
* Is there any way to create a Streaming Dataset and table using the API?  I see that the API can create datasets and tables but not sure about streaming.
* Can data in a streaming dataset table be updated?
Thank you

1 ACCEPTED SOLUTION
v-kaiyue-msft
Community Support
Community Support

Hi @fredsnertz ,

 

1. Streaming datasets is not the only way to use APIs to send data to Power BI services. power BI provides multiple methods for bringing data in, including the Power BI REST API for real-time streaming, Azure Streaming Analytics, and PubNub. each of these methods serves different use cases and scenarios.

 

2. The Power BI REST API makes it easier for developers to stream in real time. After selecting API and Next on the New Stream Processing Semantic Model screen, you can provide entries that enable Power BI to connect to and use your endpoints. Select "API" and "Step" on the "Push" screen.

vkaiyuemsft_0-1713321139448.png

 

3. After creating a report using the Push Semantic Model, you can pin any report visual object to a dashboard. On that dashboard, the visual object is updated in real time whenever the data is updated. In the Power BI service, the dashboard triggers a tile refresh every time new data is received. You can set the refresh interval for visual objects at the report page level using Automatic Page Refresh, which is active only when the page is in use. Automatic page refresh is only available for DirectQuery data sources. The minimum refresh interval depends on the type of workspace in which the report is published and the Capacity Manager setting for the Advanced Workspace.

 

More details can be found in the documentation:

Real-time streaming in Power BI - Power BI | Microsoft Learn

Power BI Real-time Streaming Dataset - RADACAD

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-kaiyue-msft
Community Support
Community Support

Hi @fredsnertz ,

 

1. Streaming datasets is not the only way to use APIs to send data to Power BI services. power BI provides multiple methods for bringing data in, including the Power BI REST API for real-time streaming, Azure Streaming Analytics, and PubNub. each of these methods serves different use cases and scenarios.

 

2. The Power BI REST API makes it easier for developers to stream in real time. After selecting API and Next on the New Stream Processing Semantic Model screen, you can provide entries that enable Power BI to connect to and use your endpoints. Select "API" and "Step" on the "Push" screen.

vkaiyuemsft_0-1713321139448.png

 

3. After creating a report using the Push Semantic Model, you can pin any report visual object to a dashboard. On that dashboard, the visual object is updated in real time whenever the data is updated. In the Power BI service, the dashboard triggers a tile refresh every time new data is received. You can set the refresh interval for visual objects at the report page level using Automatic Page Refresh, which is active only when the page is in use. Automatic page refresh is only available for DirectQuery data sources. The minimum refresh interval depends on the type of workspace in which the report is published and the Capacity Manager setting for the Advanced Workspace.

 

More details can be found in the documentation:

Real-time streaming in Power BI - Power BI | Microsoft Learn

Power BI Real-time Streaming Dataset - RADACAD

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors