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.
Hi,
You will need a data gateway connection if you are pulling data from SQL server.Please check this for more details.https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-Connection-with-SharePoint-Online/td-p/1204240