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
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
Solved! Go to Solution.
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.
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.
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.
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.