News and Announcements icon

Dynamics 365 CommunityForums Power Platform integration forum Data Driven Subscripti...

Power Platform integration forum

Suggested answer

Data Driven Subscription Replacement

(0) Share

Report

Report

Posted on by Riaan Taljaard

534

Hi all

We recently upgraded our ERP from GP2015R2 to GP18.5. We also upgraded SQL from 2012 to 2022.

We had many reports using data driven subscriptions. Our current SQL edition is Standard which means we no longer can use data driven subscriptions on SSRS. One of the reports uses a generated list of records to save a pdf file to a specific location, one for each record.

We have investigated and was able to use a combination of power automate and a power bi paginated report to replicate the above process. Unfortunately, we get an error because we do not have PowerBI premium capacity.

Does anyone have a work around or a different solution we can try?

{

/error/: {

/code/: /InvalidRequest/,

/message/: /Report requested for export is not on dedicated capacity/

}

}

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Community member 2 on at

Like (0)

Report

Data Driven Subscription Replacement

Did you try external tools like R-Tag and Roby?
Riaan Taljaard 534 on at

Like (0)

Report

Data Driven Subscription Replacement

Hi Judy

Thank you for the reply. We have created the flow as suggested in the post. My question is more around how we can do it without having reserved capacity.
Judy Microsoft Employee on at

Like (0)

Report
Data Driven Subscription Replacement

Hi,

I am not familiar with power Automate, however, based on the Microsoft Document, below are the steps of perquisites to follow to export the report in power automate.

At least one workspace in your power bi tenant backend by a reserved capacity.

This capacity can be any of the A1/EM1-A6/P3 SKUs

Export and email a report with Power Automate - Power BI | Microsoft Learn

If you have further concern, please post on the Power Automate Forum for more professional help.

Best Regards,

Judy

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2

Martin Dráb 228,166 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans