I have a requirement where the users want to generate Reports and Dashboards by getting data from external web services. This data is not stored in Salesforce. We will have to call the webservice, get the data and use it to generate view only reports.
Currently, I'm calling the webservice and displaying it on a Lightning component tab on record page but now I have to generate report out of it.
My question is, Is that possible? Can we generate reports and dashboards from the data that is not stored in Salesforce?
Any help is appreciated. Please advise a solution or point me to the right direction.