Case – Live connecting to visual studio analysis service tabular project via Power BI. Why this has happened In some cases we have millions of data which is practically impossible to load into Power BI . In such situation it is easier to live connect the data with Power BI for faster data retrieval and analysis. What are needed and why are they needed You need to have Microsoft SQL Server Management Studio for managing the databases and tables also you need Microsoft Visual Studio to create an analysis tabular project also along with that you need Power BI to live connect to the tabular project for reports and dash board creation. Microsoft SQL Server Management Studio Creating SQL Server Authentication First you need to start Microsoft SQL Server Management Studio and create a new SQL server authentication. In order to do this first login with your windows authentication which does not require any password to connect. As ...