PowerBI provided CSV format export API for Paginated Reports alone, not for normal reports which support only pbix, ppt, png formats via Export API.
Reference: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile
Is there any API to export normal PowerBI reports in CSV format?
If not, is there any API to get the exact data present in a particular report?
Can you please help me with a solution/clarity on this since am looking for it for a long time.
No, there is no API to export Power BI report to CSV. When designed properly, this should be exported from the data source, which is used to build the Power BI report itself. There are still some options to do that, but you may not like them though.
First, you can use some client library to connect to the dataset's XMLA endpoint, but this requires Premium (announcement here and for read/write here).
The other options, like Analyze in Excel and exporting data from visualization, has manual steps and bad limitations, which you may try to simulate, but I don't think this is a good solution.
As I conclusion, the best solution would be to make proper layers and avoid exporting data from the report layer at all.
