working with AzureSQL and PowerBI

[MikeSolvesBI]

Hello,

I created a PowerBI file and published to the service.  The Data Source is AzureSQL Database.

Is there a setting that I need to set in Azure SQL Database that will allow Power BI Service to read the SQL Database or is this automatic because both Power BI Service and Azure SQL Database are Microsoft Products.

Thank You,

Michael

[GilbertQ · Accepted solution]

Hi @MikeSolvesBI 

You can do this by going into the dataset settings, then scheduled refresh and update the data source credentials.