Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The data source is SharePoint Online
I have a dataset that I want to have incremental refresh enabled on it.
I follow the guide using the https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh documentation.
Due to the date format in my source table is not a standard date/time format, I have to convert it using the function. I follow the tip as in the link above. So I create a function and call it the filter step to convert the RangeStart and RangeEnd to match the format as in the source table. I have set the incremental refresh and publish to Power BI service with no problem. But when I want to refresh the dataset, I got the error as below saying that it does not recognize my function. When I disabled the incremental refresh, the dataset is able to refresh. So I guess this has something to do with incremental refresh features where it does not recognize my function in Power BI desktop.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.