Saturday, 29 April 2017

Error Connecting Power BI to Azure SQL

Azure SQL is the best data source for Power BI reports.
But it is very irritating if you can unable to connect it and find some unknown error.
So to fix it follow below-mentioned steps:

Step 1: Clear the stored credential inside the Power BI.
Open Power BI > File> Options and Setting >Data Source Setting > select data source (azure SQL)  >  Clear permission > Clear all permission> close


Step 2Loging again to azure sql 
Get data> SQL database> Provide AzureSQL server(like:abcd.database.windows.net) > provide option database>



>select database for credentials>user name > password and click ok



All Done!

Now you will not get error make sure your SQL azure server looks like this abcd.database.windows.net  and provide optional DB