Get data from Report Table using API

[Raivo_S]

Hello,

I was wondering if there is a way to pull data from table in Power BI Report using API or any other Method. Idea is to automaticly pull Data from table once a day, but what would be the easyest way to do this? And are there any limitations for the size of the Table?

Thank you!

[V-lianl-msft]

Hi @Raivo_S ,

Please refer to this rest api:https://docs.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-get-tables#limitations 

This API only applies to push dataset, please check if your dataset is a push dataset. 

When accessing Power BI REST API, your request and response content and data may be processed by data centers in regions other than the home region of your Power BI tenant.

The push dataset limitations are:

• Max rows per table depending on retention policy:
  • No retention policy: max 5,000,000 rows per table
  • FIFO retention policy: max 200,000 rows per table
• Max 75 columns per table;
• Max 75 tables per push dataset;
• Max 10,000 rows per single POST rows call;
• Max 1,000,000 rows added per hour per dataset;
• Max 5 pending POST rows requests per dataset;
• Max POST rows requests depending on table size:
  • Less than 250,000 rows in the table: up to 120 POST rows requests per minute
  • More than 250,000 rows in the table: up to 120 POST rows requests per hour

• 4,000 characters per value for string column in POST rows request;
• Data model restrictions:
  • Inactive relationships are not supported
  • Measures using USERELATIONSHIP are not supported
  • Measures referencing invalid/non existing measures are not supported
  • Hierarchies are not supported
  • Mark as Date table is not supported.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.