Forum Discussion
Formula with imported data as a connection only
I would like to create a formula which refers to imported data (from Dynamics 365). The external data has been imported with "only create connection" and added to the data model. So if I type the...
You can't pickup by formula value from data model. You may build combined table by Power Query or directly in data model and land it back to Excel sheet.
SergeiBaklan, thank you for your reply.
I will then load the data in to a new worksheet.
yes, that's also a variant. To save space and reduce calculation time you may load only columns which you need to build aggregation table.