power BI solution to excel macro

[richlyn9]

Hi All,

I have a requirement for which i have a excel macro solution however the rows are in excess of 60000 rows and hence checking to see if this can be done in Power BI.

So a breif idea of what goes on

I have transnational data in MS dynamics CRM
Since its a huge data i have an excel sheet with queries that download the updated data.
this updated file is then linked to access for data transformation
Then i have to map departments for each record based on effective data from another table/file.
for this i have to export the data from access to excel , map the dept and then import it back to access.

I am searching for a 1 stop or part solution for this but want guidance.

Hope i was clear with the summary..
please let me know for any other details.

 

[ImkeF]

I can strongly recommend this book: Excelguru Help Site - M is for (Data) Monkey