For example, if you are connecting to SQL Server database, you will see an option to choose Import Data or another option. If a connection type supports multiple connection types, then you can choose it when you are connecting to that source. Excel data source only supports Import Data Connection type. You will see that Power BI loads this data into the model.ДЄs you probably guessed already this is Import Data Connection Type. Select the Excel file Pubs Descriptions.xlsx, select all tables from the list showed in Navigator, and then click on Load. Open Power BI Desktop, and click on Get Data. To have a closer look at import data, letвЂ™s create a report with this type of connection. That is why this technique is called Import Data, or Scheduled Refresh. The process of updating the data needs to be scheduled if you are using this method of connection. Loading data into the memory also means something more data needs to be refreshed.

When you publish your report into Power BI website, it will be the memory of that machine in the cloud. If you have Power BI report opened in Power BI Desktop, then it will be the memory of the machine that Power BI Desktop is running on it. This memory will be the memory of the machine that hosts Power BI report. This type of connection imports the whole dataset into the memory. Import Data is the first type of connection, which I explain here in this post. Otherwise, you might end up with a lot of re-work. Choosing the connection type is one of the decisions that should be made at the beginning. You cannot change the type of connection in the middle of your Power BI development cycle.

One connection type is suitable for smaller datasets, one for big, one connection type is useful for better flexibility, the other for not needing the scheduled refresh, etc. It is the same data source, however different types of connections.Д®very Connection type has some advantages and disadvantages. For example, you can connect to SQL Server database with Import Data or DirectQuery.

One data source can support many types of connection. Connection Type is the way that the connection is created to the data source. Apparently, Power BI supports hundreds of data source types. Connection Type is not Data Source TypeД¬onnection type doesnвЂ™t mean the data source type. You will learn briefly how Power BI stores data into xVelociy in-memory engine, and what are pros and cons of this method in detail. In this section, we are going to cover everything about Import Data or Scheduled Refresh type of connection. Power BI is one of the BI tools in the market that supports more than one type of connection.

Schedule refresh power bi desktop