Power BI
Needs VotesMake functions refreshable when the data source is a parameter of the function
Bernd Loigge on 14 Aug 2015 03:16:28
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.
- Comments (120)
RE: Make functions refreshable when the data source is a parameter of the function
Very frustrated it hasn't got any update!!
RE: Make functions refreshable when the data source is a parameter of the function
Hi All, any updates ?
RE: Make functions refreshable when the data source is a parameter of the function
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
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
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?
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
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!
RE: Make functions refreshable when the data source is a parameter of the function
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.
RE: Make functions refreshable when the data source is a parameter of the function
Hi Gautier,
Could you explain in more detail how you used joins instead of the function?
thank you
Sebastian
RE: Make functions refreshable when the data source is a parameter of the function
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