Forum Discussion

nasirali's avatar
nasirali
Helper I
8 years ago
Solved

push data into Power BI Dataset from asp.net web api

Hi,   I am getting my data for power bi report from asp.net web api as json. As i am fetching 50-60k records, it takes time to get all data and if there is network traffic, request timeout also hap...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

kkalyanthaya's avatar
kkalyanthaya
Microsoft Employee
8 years ago

For none retention policy dataset , what is the behaviour if table reaches the max rows of 5,000,000 as specified below.

I believe it is not FIFO and there is no delete individual rows APIs available. If we need to push new data to it, how do we do it ? Is flush all the rows and start again the only option ?

 

Thanks,

Kiran