The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
Is it possible to do a scheduled refresh on a composite model?
I'm using DirectQuery on a Power BI dataset and the model is also using a Synapse data source and Excel files using Import Mode.
I get the following error when I'm trying to schedule a refresh:
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
However there are no data sources listed below the error...
Where are your Excel files located (i.e. MS Teams, SharePoint, local folder)?
The Excel files are located on SharePoint