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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors