Connection Types in Power BI: Import Data or Scheduled Refresh; A Detailed Look Inside and Out

Power BI is one of the BI tools in the market that supports more than one type of connection. Each connection type has pros and cons. In this section, we are going to cover everything about Import Data or Scheduled Refresh type of connection. You will learn briefly how Power BI stores data into xVelociy Read more about Connection Types in Power BI: Import Data or Scheduled Refresh; A Detailed Look Inside and Out[…]

Add or Edit Columns When Importing Data from Analysis Services into Power BI

If you use SQL Server Analysis Services as a data source for Power BI, you have two types of connection; Live Connection or Import Data. If you use Import Data, you can select columns and measures to be imported into Power BI. However, what if you want to add more columns to it, or edit Read more about Add or Edit Columns When Importing Data from Analysis Services into Power BI[…]