Forum Discussion
Prasanth460
1 month agoRegular Visitor
Data flows connected to SQL are not refreshing on schedule but refreshing manually.
Hi Everyone. I conneted my data flows from SQL Source and published to power bi service using my credentials. where my gateway is configured with service account. from past few days my scheduled r...
GilbertQ
1 month agoSuper User
Hi Prasanth460
One further thing to mention is if you can confirm if your service account has the permissions to connect to your SQL server source. One way to test this is to login to your gateway and connect to the database using the service account details to see if you can login and connect successfully.
- Prasanth46029 days agoRegular Visitor
Hi GilbertQ , Thanks for your response, I tested with Gateway connection ad they are working and connecting with SQL DB