in Power BI Desktop and select Home > Get Data > More…
A “Get Data” connection window will appear with several connection options. Select “Azure” on the left and under that “Azure SQL database” and click on “Connect”. A common mistake made is selecting “Azure Table Storage” which is an entirely different storage entity. So, ensure you select “Azure SQL database”.