MSBI Tutor

Step 1: Click on windows button and select import and export wizard Step 2: Select data source Select source database Step 3: Select destination server as shown in bellow Select destination database as shown in bellow Step 4: Specify table copy or query Step 5: Select tables to copy to destination database Click on next Step 6: Save and run package page looks like bellow Select save SSIS package as shown in bellow Change package save location to file system Click on next Change package name and  location Click on next And click on finish to complete task Step 7: Package created in destination folder.

Capability Import DirectQuery Size Size limitation   Up to 1 GB per dataset No limitation Data Source Combining Data from different sources Cannot combine data from multiple sources Performance High-performance query engine Depends on the data source response for each query Data Change in the underlying data Not Reflected. Required to do a Manual refresh in Power BI Desktop and republish the report or Schedule Refresh Power BI caches the data for better performance. So, it is necessary to Refresh to ensure the latest data Schedule Refresh Maximum 8 schedules per day Schedule often as every 15 mins Power BI Gateway Only required to get latest data from On-premise data sources Must require to get data from On-premise data sources Data Transformations ...

Step 1 : Open visual studio and create new project  Step 2 : Select integration service import project wizard. Click on next Step 3: Select the integration services project that you want to import as shown in bellow Click on import Step 4 : Able view imported project in visual studio