Forum Discussion
error for visual direct query with azure database
Hello, i have published a model with below tables: Customers table - was loaded into power bi desktop as a direct connect from azure database. I added a visual with columns from this table and get ...
Hi, have you entered the credentials for the DB in the Service? there is an option Data Credentials in the dataset settings (or schedule refresh menu) that will let you edit the credentials of the sources. You might need that before making it work in service.
The following link is for another thing, but check the picture to guide you where this data source credentials are just in case that's the issue: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#deploying-a-personal-data-gateway
I hope that helps,