If you use SQL Server Db in on-premise, It provides maximum of 48 times refresh limit per day with the highest license from power Bi service.
You can put the data to a SQL Server Analysis Services Tabular model and set the Model and PowerBI reports to use a Direct Connection. Also, you can refresh the SSAS model as many times as you want exceeding the 48 per times a day of limit for normal SQL Server Data sets.
Thinking of learning Power BI? Here is the opportunity provided by Intellipaat to earn a certification in Power BI Course.
Back