Forum Discussion

nottyheadedboss's avatar
nottyheadedboss
Frequent Visitor
2 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

 

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.