Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
lmarangio
Helper I
Helper I

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

 

4 REPLIES 4
lmarangio
Helper I
Helper I

This one is still open. 

lmarangio
Helper I
Helper I

Still open. 

v-shex-msft
Community Support
Community Support

HI @lmarangio,

>>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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Sorry to say @v-shex-msft  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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.