power bi rdl subscription not working

[Anonymous]

so I built a power bi rdl using power bi report builder (source data is power bi dataset)...and published it on power bi service

Now, i went into the report and subscibed it selecting excel as the option, however, i am not getting email with attachment. what am i mising

[GilbertQ]

Hi there

Just to confirm you are running on Power BI Premium?

And that you have a table for it to export to Excel?

[Anonymous]

yes, i can see diamond next to the workspace, so its premium

yes, i was able to independently open the report, and export to excel

[GilbertQ]

Hi there

As far as I know it should then work.

What happens if you try a different attachment?

[Anonymous]

works for pdf attachment, not for excel, strange !! Also, pdf attachment is not able to hold all the columns in one page

My user wants attachment in excel though. Is there a way I can contact power bi support group from microsoft who can look into this please ?

[Anonymous]

working for csv attachment too.

[Anonymous]

After multiple testing confirmed the power bi report builder rdl published in power bi service only works for csv / pdf attachments, does not work for Excel attachments

[GilbertQ]

Thanks for letting us know.

[Anonymous]

Please advise if there is an email / contact / Forum thread where i can bring this to the attention of Microsoft power bi team ?

[GilbertQ]

Hi there

Currently this is not supported. They are looking to support more formats in the future.

You can vote for it on https://ideas.powerbi.com

[Anonymous]

Done, please advise how the new idea forum works ? Microsoft will look into the most voted idea for a certain time period and implement the feature ?

[bradsy]

RDL subscription should work for Excel.  When viewing the report in the PBI portal, can you successfully export to Excel?

---

[Anonymous]

what is "power bi portal" ? so i have an rdl developed in report builder, source for this is power bi dataset

Now I publish this rdl on the service, and just like any other report, i subscribe it and choose excel as attachment format, I don't get subscription emails...however, it works for csv attachments....

Documentation may mention excel but its not working...you may please try it once as an example. Note the requirement is user wants email in his inbox with report attached. Thats what I am trying to achieve here.

[GilbertQ]

Hi there

I can confirm that this is correct as shown in the link below

https://docs.microsoft.com/en-us/power-bi/consumer/paginated-reports-subscriptions

[Anonymous]

sorry but excel attachment to email doesnt work when I subscribe an rdl report....csv works.