Refresh odbc data source every 5-15 minutes on power bi service

[elukianic]

Hello All,

I developed a dashboard that needs to be refreshed every 5-15 minutes. I am using an ODBC connection with Advantage StreamlineSQL ODBC driver. In power bi service i can set up automatic refreshes only 8 times a day. It is not enought for us to make the dashboard usefull. What are my options?

[GilbertQ]

Hi @elukianic 

You have to have PBI Premium or Premium Per user to refresh more than 8 times per day.

Then to do this you could follow the following blog post: Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

[elukianic]

i have this. But why does it stop at 8 times when i try to schedule refresh?

[Anonymous]

Hi @elukianic ,

In my opinion, there are two choice suitable for you:
1.create a script to call the Power BI refresh API to refresh the report
For more details, you can read related document:Datasets - Refresh Dataset - REST API (Power BI Power BI REST APIs) | Microsoft Docs , Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

2.by using RPA tool , such as Power BI Automate

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[elukianic]

Number 1 option is not limited to only 8 requests a day? and also how do i implement this? I never did apis before? is there a better tutorial i could follow?

[Luca_Yu]

Hi @elukianic ,

The first option is to call Refresh API , this API hasn't limited times.

Please refer this case: Solved: Refresh via API? - Microsoft Power BI Community 

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

[GilbertQ]

HI @elukianic 

Your options are to use Power BI Premium Per user (where each user viewing the report/dashboard also needs a Premium Per User license) or Power BI Premium (where you buy capacity and many users can view the report/dashboad using Power BI Free)