Dataverse: Download SSRS Report using Custom API
This article discusses how to download SSRS reports from Dataverse using pro-code instead of low-code methods. The author addresses some challenges, such as accessing the report viewer page using an Application User, which requires creating a user without MFA and assigning the necessary permissions. The article provides steps for creating an Environment Variable with the required values and shares code for a Custom API that retrieves the access token and processes the report. The author also demonstrates how to call the Custom API in Power Automate and explains how to obtain the report name and XML for filtering the data.
Article 9m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time