Forum Discussion
Cannot use composite model
I currently have a DirectQuery model created from a SQL Server query. Now I want to add an excel file import to create a composite model. But when I add the import, a popup says if I want to continue...
I don't think so. Here are some example steps:
1. Create DQ model:
2. Add Excel import:
3. This message pops up:
There must be something wrong with your settings. I tried at mine and worked fine. Any chance you have this button on?
Check your global and current file settings.
Does the DQ work fine just by itself, without adding the excel file? Can you load the data to desktop?
Any chance your privacy settings on desktop would not allow it?