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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nottyheadedboss
Frequent Visitor

PowerBI Refresh - Single table vs Multiple tables

I have a question with respect to the Power BI refresh timings.

I have a table (Table 1) which has got about 1.9 billion records and there are no relationships in this table. This is the only table that is present in Delta Tables using ADBX.

 

While I have another table (Table 2) with about 40 GB of data at 8.5 billion records which is connected in a relationship with two other tables each having about 1.8 GB each.

 

I have created incremental partitions on both the tables. And this have been implemented using tabular Editor's "Apply Refresh Policy".

 

The refresh of Table 1 which has about 1.9 billion records takes about 2 hours to process, however the refresh of a table (Table 2) having multi partitions with the granularity at day level with about 1.6 billion records fails. I am refreshing data for a particular month alone. I am using XMLA Endpoint to accomplish the refresh.

 

However if I process Table 2 in groups of 4 to 5 partitions upto 8 partitions, the table successfully refreshes without any issues.

 

So would it be okay to say that if a table has multiple relationships and a refresh is set up the refresh timings would be slower compared to the table with no relationships?

 

Thanks

1 REPLY 1
v-rongtiep-msft
Community Support
Community Support

Hi @nottyheadedboss ,

From your description, it looks like the Table 2 refresh failed. Can you tell me if there is any error message reported for the refresh failure? Is it caused by refresh timeout? 

Regardless of incremental refresh, Power BI Pro models have a refresh time limit of two hours and don't support getting real-time data with DirectQuery. For models in a Premium capacity, the time limit is five hours. Refresh operations are process and memory intensive.

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

 

Could you please provide more details about the error?

 

Best Regards
Community Support Team _ Rongtie

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors