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 2 : Loging 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

PowerBI Desktop Query Editior Tips – Listing all functions of M Code

Open a Blank query and in formula bar write = #shared and hit enter to list all M code function used in power query, click on function name for more detail about M code function.

Steps: Open PowerBI Desktop –  Edit Query – From Other Source – Blank Query – Formula bar – write = #shared  – hit enter