The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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.