Connecting Power BI to a SQL database

Power BI - Is a complete reporting solution that offers data preparation, data visualization, distribution and management through development tools and an online platform. Power BI for Data Analysis and Business Intelligence Helps track key performance indicators (KPIs). Monitor business operations. Identify trends. Generate reports that help management make strategic decisions. ## Get Data In Power BI The Get Data tab on the Power BI desktop helps use load data from various sources to our Power BI for the data visualization and report. The various data sources are namely: (i)Flat File (ii) Relational data (iii) NoSQL database (iv) Online Service (v) Azure Analysis Service Connecting Power BI to SQL Database We understand that the SQL database can be hosted on cloud or on premise. On-Premise Database - is a database that is hosted on servers located inside a company’s physical infrastructure, such as their data center or office server room. Example: a company installs Microsoft SQL Ser