The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
43 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
51 | |
31 | |
20 | |
18 | |
15 |