Unable To Refresh Queries Which Are Using Functions As a Reference To Access Data

[Deepesh_V95]

Hi,

We have been building a content pack and in the reports of the content pack we have used certain functions.

When we publish the report in Power BI Services, we can't refresh it.

The data access happens inside a function and this function is referred in other queries to access data.

I think maybe this is the problem, as the function used is stopping the schedule refresh of the dataset.

Take a look at the below screenshots:

In the above screenshot, function 'fxGetSource' is used in the queries like (Deliverable, Issue, Poject etc). The data access happens inside this function 'fxGetSource'.

When we try to refresh the report and dataset in Power BI service it shows the below error:

Can anyone please let me know how to fix this error?

As this report is for a content pack, is there a way this function can be moved from a .PBIX file to the .mez file so as to get rid of error?

Or any other possible solution?

Please do let me know.

Thanks!

[v-haibl-msft]

@Deepesh_V95

Queries where data access happens inside a function and where the data source is dependent on parameters to the function can't currently be refreshed in Power BI Service.

You can vote on existing idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

And here is a blog which talks about the alternative which maybe helpful to you.

Best Regards,
Herbert

[Deepesh_V95]

Thanks @v-haibl-msft.

Also, is there any possible way we can refer any function in a query from outside the .PBIX file.

For ex. - Here in the below screenshot in 'Deliverable' query fxGetSource function is called and in place of fxGetSource I want to use any other function from different file.

So,

How can I refer a function from any other file(Lets say a .M extension file) to the queries used here?

Thanks and Regards,

Deepesh