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.
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.
