Forum Discussion
Helper IVPower 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.
Helper IVHi,
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.
Helper IIIDo you use a Windows Account or a SQL account to connect to your SQL Instance?
- Jarrod
Use Windows Authentication for the data source then.
When you change to SQL, change to "Basic Authentication" and put in your SQL credentials.
- Medmbchr
Windows for the time being, but I can change it to SQL. The thing is that Data source tab gives me choice between Windows credentials and no credentials only.