Forum Discussion
Solved
Best Practice for using Excel mapping file in a composite model
Hello, I have a semantic model which I need to enrich with an offline mapping table in Excel. I am aware I can turn this into a composite model by bringing in data from Excel. However, looking to...
Put the Excel file in SharePoint Online. That will let you schedule refresh without using a gateway. You can have direct query and import mode sources in the same dataset.
Put the Excel file in SharePoint Online. That will let you schedule refresh without using a gateway. You can have direct query and import mode sources in the same dataset.
Thank you, Will I need to schedule any other refresh once I create a live connection from a shared worksplace to this model saved in my personal Workspace?
In your experience, does it impact performance when there is a live connection to a model which in turn is using a DirectQuery for the fact table?
Thanks