I've uploaded the Scheduled Report.json, made all the connections and so far so good, but the issue I'm encountering is that the Excel file that the automation creates in my SharePoint is not being populated at all (screenshot of the error attached).
Does anyone have an idea how I can handle this issue? I'll be happy to provide any further details if required.
Regarding automations - the article you have followed was written more than 2 years ago and it was a workaround as at that time we did not have "Tabular Reporting functionality " and "On Demand" functionality built in.
There could be many factors like new objects (in the past there were only standard pivot and straight table), if you have used new ones you may be affected by it or excecl API could have changed... At the time I spend hours working on this and from my experience it was waste of time as the final result was poor, you had limited control over the look and feel of outcome and by using Tabular reporting the output was easier to build, update, control and distribute.
Let me know your thoughts about using tabular reporting and as much as I aknowledge I am not answering straight up your question I am open to discussion about pros and cons either of solutions.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
