Last year I built a Power BI dashboard to report the grape intake to our wineries over harvest here in New Zealand. I connected to the data using an API that required a “bearer token”. This token does not change. I could not get a scheduled refresh on the online service to work unless I used an Azure proxy. This was a solution I read about online (I am capable, but not an expert!).
Near the end of the harvest the scheduled refresh often failed due to Azure timeout.
I was not using incremental refresh because of the bearer token / proxy, so each refresh returned the entire data set (which ended at 3,200 rows and 69 columns - essentially one row per truck delivery).
Is there another approach I can take this harvest to reduce the risk of refresh failure? Can I avoid using an Azure proxy?
Hi @Jeremy, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
Hi @Jeremy, we’ve noticed that no response has been received from you since the 11th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!
