Refresh the report every hour through stored procedures in SQL

[neelofarshama]

Hi,

I have my dashboard built using the stored procedures in SQL Server, I want my Power BI reports to refresh every day in frequency of one hour, also I should display a note in the dashboard stating when was the data last updated.

How can I achieve this any help woukd be highly appreciated.

Thanks in Advance,

Neelofar Shgama

[V-lianl-msft · Accepted solution]

Hi @neelofarshama ,

In directquery mode there is something called "Query Folding", this will by no means happen if you use a stored procedure.

I guess you are using import mode, which is limited by the number of refreshes under different licenses.

Power BI limits datasets on shared capacity to eight daily refreshes. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings. For more information, see Configure scheduled refresh in this article. 

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

[amitchandak]

@neelofarshama , You can schedule a refresh - https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

there can be a limit, in case you have pro license