Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
In connector that has one entry point:
[DataSource.Kind="Solar", Publish="Solar.Publish"]
shared Solar.Contents = () =>
I tried to add a parameter to this root function like
shared Solar.Contents = (optional RangeStart as datetime) =>
and use this parameter in our code
This seems as compiled successfully, which is great, and lead to an option that our connector can get external parameter (like RangeStart that we can declared in Power Query Editor Manage Parameters)
In Power BI Desktop it works fine when I add the parameter in the call to our connecter:
When I refresh the report – its use the RangeStart value. Which is great also.
But – when I tried to publish a report based on this model based on this connector to Power BI service with the RangeStart paraeter – its lead to not working dataset – and raise an error
If I remove the parameter from the root, the error does not raised
I haven’t set the incremented refresh on the model yet, but even when I add incremented refresh setting – its lead to same error.
What am I missing?
Thanks,
Hi @lbendlin
Thanks for your feedback,
Why do we need to use RelativePath and Query ? where in the documentaion it ask to do that?
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot#configuring...
Nothing will work unless you specify both RangeStart and RangeEnd in your filter? where it is also mentioned as a must to use in the connector? What if I need it to be since RangeStart till now?
Thanks
You may need to use RelativePath to avoid issues with service refresh. RangeEnd is absolutely required but can be a date in the future.
You are missing two things.
1. you need to change your source query to make it non-dynamic. Have a look at the documentation for Web.Contents - it has great examples of how to use RelativePath and Query
2. you are missing the RangeEnd filter. It is critical for Incremental refresh. Nothing will work unless you specify both RangeStart and RangeEnd in your filter.
That part of the code looks good. Please provide more details.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
9 | |
6 | |
3 | |
3 | |
2 |