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 are some limitation on the underlying dataset in PBI; for instance, when creating a push dataset with RetentionPolicy “None”, you have a limit of 5.000.000 rows per table, and limits on the amount of requests you can send to the PBI API: Power BI REST APIs push datasets limitations – Power BI | Microsoft Learn

 

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? 

What kind of dataset PBI creates when I create a connection between Azure table and PBI?

 

Thanks for the help,

Luigi

 

Read more here: Source link