Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI - Azure table storage - Limits

Hey community, following this giude Connect to a knowledge store with Power BI - Azure Cognitive Search | Microsoft Learn I connected  my azure table storage to Power BI. I was wondering if there a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

>>So what happen if I ingest 6.000.000 of entities in my Azure table? They will still be processed by PBI? If I insert 20.000 entities with a single request in the Azure table, they will be ingested in "real time" in PBI? 

These should be considered with operation methods, if you directly use rest API to push the data over the limit amounts, the request will be failed and got the response about exceed to the limit.

If you split these and push them in batch, some of the records can be pushed successfully and power bi will return message when requests amounts are exceeded to the limitations.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry to say Anonymous  but looks to me that you did not read properly my question. The behavior you are describing is the behavior of a push dataset in PBI; the question is different! What happen when I create a connection between an Azure table and PBI trough Power BI Desktop? What kind of dataset PBI creates (if any)? What are the limits of this connection? There is no limit on the entities that I can put in an Azure table, what are the limits on PBI then? Thanks.