1194
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.
STATUS DETAILS
Needs Votes

Comments

B

Hi All, any updates ?

B

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

B

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.

B

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?

B

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.

B

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!

B

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.

B

Hi Gautier,

Could you explain in more detail how you used joins instead of the function?

thank you

Sebastian

B

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

B

Same for me, even though the power bi service doesn't report any refresh error (when looking at the refresh history) the result after refreshing is completely different from what I obtain if I refresh the same model on power bi desktop.

So I assume that this is still not supported by Power BI service. Is there any plan to let us refresh data models that contain powerquery functions ?