Forum Discussion

Advocate IV

11 years ago

Solved

Refreshing queries with functions doens't work

Does anyone else experience that refreshing on-premise data via a gateway (for example amount of files in a folder) works if you hardcode the path to the folder, but when you create a function where ...

konstantinos
11 years ago
Maybe try this approach..and filter the latest file by date created..Needs more code but it worked - refreshed in PowerBI V1 so probably it will work in V2 as it doesn't use parameters..

http://www.poweredsolutions.co/2014/11/21/combining-data-from-multiple-excel-workbooks-with-power-querythe-easycompletepower-bi-ready-way-2/

miguel

Community Admin

11 years ago

I've tried using a function from an Azure Machine Learning Web Service and it works perfectly. I've tried others that work over a set of tables from Excel Files and also from a SQL Database table and they work great as well.

Is there any chance that you can paste the M code here so we can take a look?

konstantinos

Memorable Member

11 years ago

miguel I still didn't find a way to refresh the data in PowerBI service with AzureML OData source..Although in PBI desktop or excel is refreshing..

http://community.powerbi.com/t5/Service/Azure-ML-odata-amp-Refresh/m-p/2516#M694

I must do something the wrong way..

Forum Discussion

Refreshing queries with functions doens't work

Related content

Refresh Direct Query not refreshing

Regular Expression Functions (REGEX) in Power Query

Query contains unsupported function. Function name: Resource.Access

Excel Power Query Refresh

Question about Power Query functions