cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
avioti Frequent Visitor
Frequent Visitor

PowerBI Report - Scheduling and Send by Email

Hello Guys

 

I would like to schedule and send a report once a month for a person in my department.

Do you know if its possible? and How do I do it?

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

Re: PowerBI Report - Scheduling and Send by Email

@avioti You can have them use the new subscribe feature - here

They will need to subscribe to each page they want to have emailed to them.

 

Be aware, this would be after you share the dashboard with them. They would need access to see the report first, then would be able to add the subscription as described above.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Super User III
Super User III

Re: PowerBI Report - Scheduling and Send by Email

@avioti I don't believe this can be automated, but you could use Analyze in Excel to build them a pivot table and work with it. Otherwise, I'm not aware of another way to share content in this way.. almost sounds like SQL Reporting Services is a better fit for this...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

11 REPLIES 11
Super User III
Super User III

Re: PowerBI Report - Scheduling and Send by Email

@avioti You can have them use the new subscribe feature - here

They will need to subscribe to each page they want to have emailed to them.

 

Be aware, this would be after you share the dashboard with them. They would need access to see the report first, then would be able to add the subscription as described above.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

avioti Frequent Visitor
Frequent Visitor

Re: PowerBI Report - Scheduling and Send by Email

Actually, my report is a spreadsheet that the user will need to manipulate the data. Is it possible?

Super User III
Super User III

Re: PowerBI Report - Scheduling and Send by Email

@avioti Manipulate how? Could you describe the process/purpose of the report? I don't want to steer you wrong without understanding what it is you are trying to do...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
avioti Frequent Visitor
Frequent Visitor

Re: PowerBI Report - Scheduling and Send by Email

Such as create a pivot table with the information

Super User III
Super User III

Re: PowerBI Report - Scheduling and Send by Email

@avioti I don't believe this can be automated, but you could use Analyze in Excel to build them a pivot table and work with it. Otherwise, I'm not aware of another way to share content in this way.. almost sounds like SQL Reporting Services is a better fit for this...


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Adigan_MSFT Frequent Visitor
Frequent Visitor

Re: PowerBI Report - Scheduling and Send by Email

Hello, 

 

If there is a long list in the report, a snapshot is sent via email, which clips a huge portion of the list. 

Is there a way to send the whole list, which would normally need a scroll in the dashboard?

 

Thanks!

Adigan_MSFT Frequent Visitor
Frequent Visitor

Re: PowerBI Report - Scheduling and Send by Email

Hello,

 

Currently, the reports that are sent are more like screenshots. eg, if a report has a scroll bar, the users only see the part in the scroll, and the rest of the list gets clipped. Is there a way to send the whole list as a report?

 

Thanks!

 

Highlighted
csssoft Frequent Visitor
Frequent Visitor

Re: PowerBI Report - Scheduling and Send by Email

You can schedule and send the entire report (instead of just a screenshot snippet) by using this third-party Power BI Reports Scheduler.

ggorham2 Occasional Visitor
Occasional Visitor

Re: PowerBI Report - Scheduling and Send by Email

The most common use case I've wittnessed in a business is the ability for a end user to schedule a matrix report via a email distribution so they can use the data and analyze.  I'm not seeing this as an available feature since the new subscription feature is just a snippet.  The typical ask is a CSV or excel format scheduled.   

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors