Forum Discussion
Power BI Report Server : Refresh data on a report
Use Windows Authentication for the data source then.
When you change to SQL, change to "Basic Authentication" and put in your SQL credentials.
Hi,
Great! I found it, thanks.
Since I don't have the credentials to be connected to be able to test it (need to use my client's computer), I'd like to know in advance how many times does this scheduled refresh allows you to refresh your report per day?
Regards,
Scheduled refresh can be configured as often as you like, however I'd advise against refreshing as often as every minute.
You should still have SQL credentials. These are configured when you set SQL up. I assume you are running the SQL code against a database? You would need these to run in SQL Server Management Studio..
Hi,
I'd like to set up an SQL credential, but if you check Data Source tab, you'll notice that it gives you choice between a Windows Authentication or a basic authentication (with no login or pwd).
What should I do in this case?
PS: I won't refresh every minute, each dashboard will be refreshed accordingly with the right intervale but it won't be a minute for sure, maybe half an hour but for one dashboard only.