We use Kinetic and I would like my reports written so that in excel I can just click refresh or get data and my BAQs are refreshed in my excel file.
Is this possible?
Are there instructions on doing this?
My IT Dept. is not aware of how to do this.
Yes, I’m not sure we have a definitive guide, but we do have some threads on it.
This thread has a bunch of ways to do that.
I got a fairly detailed guide on how do… il upload it when I am in the office in the am.
It’s just leveraging the oData feed for the BAQ as the data source.
That’s the one I was trying to think of.
Nowadays I’m recommending getting familiar with Power Query. If you’re on SaaS and fetching data over REST, it’s far more powerful at handling data than VBA. It also ports directly to Power BI if you go that direction in the future.