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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ani1991
Resolver III
Resolver III

Does refresh frequency differs for different Data sources used?

Hi Team,

 

Greetings of the day!!

Does refresh frequency differs for different Data sources used in Power BI. By this I mean, if suppose I am connecting to a HIVE datasource using an ODBC connector will that provide me different refresh cycles instead of 8 times/day in Pro licence.

 

Any help is highly appreciated.

 

Thanks,

Ani

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Ani1991 ,

For data refresh in Power BI, you can refer to this article.

1. For on-premises data sources, 

    If you choose 'import', 8 times schedule per day for pro license. If you choose 'DirectQuery' or 'LiveConnect', data refreshes when you open the report or interact with the report.

2. For cloud data sources,

    Just for data sources in OneDrive for Business Online and SharePoint Online, data refreshes hourly.

 

Best Regards,

Icey

 

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

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @Ani1991 ,

For data refresh in Power BI, you can refer to this article.

1. For on-premises data sources, 

    If you choose 'import', 8 times schedule per day for pro license. If you choose 'DirectQuery' or 'LiveConnect', data refreshes when you open the report or interact with the report.

2. For cloud data sources,

    Just for data sources in OneDrive for Business Online and SharePoint Online, data refreshes hourly.

 

Best Regards,

Icey

 

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

AnthonyTilley
Solution Sage
Solution Sage

Unfortunatly not 

the maximum refresh frequancy for a pro license is 8 times per day 

the premium license allows for upto 48 times per day 

 

Alternative is to have a direct query which is able to refresh everytime you open the report or click the refresh button with in the report but these have limited functionality and can make your model very slow 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.