Power BI Online is not capable of importing Microsoft Access Database file (both mdb and accdb). To use MS Access DB as a datasource to conduct analysis, we should have to use Power BI Desktop first. You should open Power BI Desktop application and follow “Get Data > More > Database > Access Database” menu
There is a simple and effective way to toggle between Report, Data and Model views in Power BI Desktop Application. You can use left hand side toolbar menu to achieve this quickly. Default view is Report View. Power BI Desktop Application starts with this view. It is used for designing and viewing a report. Second
You can here download two Microsoft Access sample database to use it in your tests while learning.
There are several methods to store the your data into Object Variable in SSIS. (See: SSIS – Mapping Full Resultset with Execute SQL Task to Object Variable) The second method is by Dataflow Task and a Recordset Destination. 1. Drag and Drop Dataflow Task to Control Flow 2. Create a Object Variable 3. Drag and drop
Execute Sql Task in Control flow allows you to get a full resultset of your query. Full result set could be stored in Object typed variable to use within other places in SSIS. 1- Drag&drop a Execute SQL Task to Control Flow 2- Create a variable with object type: 3-Create a connection to MSDB and
Foreach Loop container in SSIS allows you to loop over the values of the object variable and store the necessary information as a result set to variables to be used anywhere in SSIS for different purposes. 1- Create a object variable and fill it with information: See: SSIS – Storing Dataflow results to Object Variable with