So I have several google AdWords accounts which are shared to 1 central account.
I added the central account via my Windsor demo, and the shared accounts showed up so I chose the 4 I need.
I generated the URL using the onboarding page.
The data comes in great, and because I chose a date in the future it contains todays current spend data.
So I setup a very simple card filtering to just one of the 4 accounts, filtering to today only and totalling the spend on that account. I Called it ‘Todays spend’, it matches what is currently on the adwords portal.
I made a graph showing historical data in that range too… all good.
I chose a future date as I want to report to keep showing live data as we progress. when I pay for Windsor I plan to use a date way in the future.
This is a live account and spending is currently ongoing so ‘todays spend’ is increasing by the minute so the number in the AdWords portal is climbing…
The Powerbi report is stuck on £781.22, no matter how many times I refresh it doesn’t change. The adwords portal is on £850 by now.
If I go into the data source settings and slightly change the URL dates for example change it to …
It refreshes and gets the current ‘Todays Spend’ which matches the portal, However it does not continue to grow and stays on £850
If I switch the URL back to the first one I use then todays spend drops to £781.22 again.
I can specify another date range the get the current ‘todays spend’ but only once, once this range has been used then ‘todays spend’ seems static again for that URL.
Any Ideas how I can get it to refresh correctly with the static URL ?.
My next question once the above works is how do I get the published (Premium capacity) report to refresh its dataset on a schedule? It wont at the moment, it has a yellow triangle and It tells me that it needs authorisation details, but I thought it authorised by the API key in the URL? Maybe I need to tweak the connector details so PBI knows where to insert the key for auth once published ?