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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Dev_SS
Regular Visitor

Power BI streaming dataset and historical data analysis using API

Hello Team,

I have two quick queries to check with my development. I am working on an integration with Power BI REST API mode for streaming dataset. 

1. I am planning to push huge amount of data to the streaming dataset. I got a API URL having the auth in itself to push a row to the table in JSON format. Will I be able to use the same API url to push huge amount of data in batches and if so what are the limitations in it ? Also is it account on plan based ?
2. I wish to push large data only to those datasets that has historical data analysis toggle enabled and I wish to fetch if the toggle is enabled or not using APIs. How to do that and does it require any authentication or oauth or only the dataset ID ?
3. Using the public API url is there anyway we can get the dataset data like is historical data analysis toggle enabled or not ?

Thanks in advance.

1 REPLY 1
lbendlin
Super User
Super User

Power BI REST APIs push datasets limitations - Power BI | Microsoft Learn

 

Streaming datasets use a key for authentication. If you know the key and the dataset ID then you can push rows into it.

 

Push Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn

 

I am not aware of a way to query the "history enabled" flag via API.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.