Make functions refreshable when the data source is a parameter of the function

[bloigge]

Like discussed here: http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-t-work/td-p/2450 - queries where data access happens inside a function and where the data source is dependent on parameters to the function should be refreshable.

[Gautier]

Hey Guys, I found a workaround. Instead of using function to call another query you can use joins. At least it worked for me and then the refresh works in PBI service as well

[sebastian_vanlo]

Hi Gautier, Could you explain in more detail how you used joins instead of the function? thank you Sebastian

[sebastian_vanlo]

Same issue for me, works well in Power Desktop but not when published on the portal. I cannot refresh my datamodel anymore and so this great solution for Desktop is useless for Power BI portal. So a solution to this problem is very much appreciated.

[nakia1]

Please get this sorted! Cant believe I spent all this time building a report in BI Desktop and it is now useless in the online service!

[nick_stokes]

Was really happy with my Power BI dashboard that used functions to build tables, but was then disappointed when I couldn't schedule an update. I had to go and re-build the dashboard again using the long method just so it could refresh.

[pbiideas1]

If use static web query link - gateway and report works well ( http://10.10.10.10/ERP-Orchids/hs/getting/20150101 ) But when I added calculated variable to link, PowerBI Desktop report works well, but I cant add gateway to report: ( v = Text.From( DateTime.LocalNow () ) "http://10.10.10.10/ERP-Orchids/hs/getting/" & v ) Is there way to use calculated variable in web query with gateway?

[tchilcote]

Yikes, this breaks my 26 reports for auto updates. Would be nice to have parameters included in the data src. Looks like I will manually link each src file.

[christine3]

Very frustrated it hasn't got any update!!

[gary_bowers1]

This looks to me like a product maturity issue, Oracle SAP provide this functionality in scheduling facilities whereas PowerBI only provide it for desktop which is in effect of little value to a production environment. My work around is to create the same functionality in excel and publish to SharePoint which is OK as the dimension changes rarely and the user refreshes the model when needed

[tristan_malher1]

Hi All, any updates ?