Pass a function name as parameter in Query Editor

[ValeriaBreve]

Hello,

I have a report where I need to change quickly the data source from Onedrive to the server for several queries.

I use a parameter to indicate the path, but then I also need to change the function (Web.Contents to File.Contents and viceversa).

I have tried to set it as a parameter (File_Type being either Web.Contents or File.Contents), but PowerBI does not let me do that:

Expression.Error: We cannot convert the value "Web.Contents" to type Function.
Details:
Value=Web.Contents
Type=[Type]

Is there another way to do this?

Thanks!

Kind regards

Valeria

[v-yalanwu-msft]

Hi, @ValeriaBreve ;

You can check if these related post can is useful to you.

https://community.powerbi.com/t5/Desktop/Expression-Error-We-cannot-convert-the-value-x-to-type-Text...

https://stackoverflow.com/questions/36212091/power-bi-query-to-web-service-error-expression-error-we...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.