Anyone know how can we fix that issue i want to refresh my report after publish and schedule it also.
You’re seeing this because Power BI Service cannot find the custom M functions used inside your model. The message
Unknown function: Speckle.GetByUrl / Speckle.Utils.ExpandRecord
means the dataset was published using the Speckle Power BI connector, but the gateway does not have that connector installed.
To get scheduled refresh working, check the following:
1. Make sure you are using an On-premises Data Gateway (Standard mode)
Scheduled refresh with custom connectors does not work with Personal Gateway.
2. Install the Speckle connector on the gateway machine
Take the same .mez or .pqx file you used in Desktop and place it in the gateway’s custom connector folder, for example:
C:\Users\<gateway service account>\Documents\Power BI Desktop\Custom Connectors
Restart the gateway service afterwards.
3. Enable custom connectors on the gateway
Power BI Service → Settings → Manage gateways → select your gateway → enable the “Allow user to use custom data connectors” option.
4. Rebind the dataset to that gateway
In your workspace:
Semantic models → your dataset → Settings → Gateway connections.
Power BI should now recognise the Speckle data source and allow mapping.
Once these steps are done, “unknown function” errors disappear and scheduled refresh works normally.
thank you so much for this information Jonathon i will try that