Hi @nasirali,
If you push data to streaming api, it should be streaming dataset.(streaming dataset not cache data, it can only use with specific tiles)
If you mean publish data to rest api and create dataset who stored in power bi service. It should be a normal dataset.
I'm not so sure for timeout issue which you mentioned, but I think you can write a loop function to split these data to suitable size/interval and push them.
For power bi rest api limitation, please refer to below link:
Power BI REST API limitations
To POST Rows
- 75 max columns
- 75 max tables
- 10,000 max rows per single POST rows request
- 1,000,000 rows added per hour per dataset
- 5 max pending POST rows requests per dataset
- 120 POST rows requests per minute per dataset
- If table has 250,000 or more rows, 120 POST rows requests per hour per dataset
- 200,000 max rows stored per table in FIFO dataset
- 5,000,000 max rows stored per table in ‘none retention policy’ dataset
- 4,000 characters per value for string column in POST rows operation
Regards,
Xiaoxin Sheng
Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.