Answered

Export To File for Power BI Reports - Licensing

(0) Share

Report

Posted on by LP-22072109-0

Hi all,

I attended the MPPC conference in Vegas two weeks ago, and was excited about the "Export to File for Power BI Reports" functionality in Power Automate. Unfortunately, it does not seem to work with our licensing. I am using the Power BI Premium Per User license with a Premium Per-User workspace. When I try to use it, I get the following error:

I'm finding this very frustrating (and can tell from posts from 2020 that I am not alone). This seems like fairly basic functionality and I don't understand why we would have to pay thousands of dollars per month to get something so basic working.

How can I (or we as a community) get Microsoft to enable some of this simple functionality without having to go Premium? I would like to be able to test this as a proof-of-concept at a minimum...

Thanks!

(Cross-posted in Power BI Forum.)

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LuukP

Unfortunately this isn't really a Microsoft issue, or making them allow you to do it without the proper license. To do this, it requires dedicated storage, which they aren't simply going to give for free to everyone.

I do get the frustration, but essentially you want them to give away tons of resources for free so one person may or may not print a report. You wouldn't do it if it was your company, not sure why you want them too.

But again I understand the frustration.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
LP-22072109-0 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks @FLMike - I appreciate your input and perspective.

I don't disagree with your comments - however, for a smaller business that wouldn't have huge storage requirements, I feel there could be better options.

For example, I would have at most 20-30 users that would actually use this functionality a few times a month, which I don't feel would require much storage (each image of a Power BI report has to be less than 25Kb as I understand it). So, perhaps one option for Microsoft might be to be able to use this connector to save the file as a blob to SharePoint, which we do already pay for?

I honestly don't mind paying for storage - but I doubt I'd need more than a GB per month (or even a year), and that's where the cost of Power BI Premium is simply too prohibitive.

Kind regards,

Luuk

Was this reply helpful? Yes No
Verified answer

LP-22072109-0 28 on at

Like (0)

Report
Copy link

Link copied!

It turns out that I was the problem...

Given that I have Power BI Premium-Per-User and a Fabric trial set up, I missed the step of assigning my Workspace to the Trial Capacity (Power BI -> Admin Portal -> Workspaces -> select the workspace, click the elipses and select "Reassign Workspace" -> Select Trial

My workflow now sends me the image of the Power BI report I wanted.

Thanks,

Luuk

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey @LuukP I've been trying to use "Export to File for Power BI reports" in power automate, however, I haven't been successful yet.
Were you able to use it on the Premium per user license which is $15/mo if im not mistaken? I'm not sure which option would be best and not $150/month per bot/automation or $5k/mo for Premium Capacity.

I just need it on one report.

Any feedback would be highly appreciated!

Was this reply helpful? Yes No
LP-22072109-0 28 on at

Like (0)

Report
Copy link

Link copied!

Hi @S_Zaidi , Yes, I have this working with the Premium per user license.

As I haven't deployed the scenario yet, I don't know yet what the best option will be for us for pricing (for about 50 users). But as far as I can tell, just using the Premium per user license works, as that's all I've got.

Luuk

Was this reply helpful? Yes No