Jan 10 2021 01:29 AM
Jan 10 2021 02:16 AM
@Aread62127 Have a look at PowerQuery (PQ). It allows you to connect to data sources without loading everything into Excel. Since you ask the question, I assume that you are not familiar with it. Perhaps wise to have a look at the information in the attached link. Then you will get an idea of what PQ can do.
Jan 10 2021 03:58 AM
Jan 10 2021 04:22 AM - edited Jan 10 2021 04:22 AM
@Aread62127 No problem, you can load the data into the Data Model. More about that in, for example, the link below: