Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kolturra
Helper IV
Helper IV

Download Agent Wise Reports in PDF automatically using DAX

Hi All,

 

I am working on project in which i am planning to download the Agent wise report in PDF automatically, I use to do this activity in Excel converting range in PDF using VBA. Is their anyway we can do this by using DAX or M query ( i don't have idea on M query)

 

Thanks,

K Raghavender Rao

2 REPLIES 2
v-diye-msft
Community Support
Community Support

Hi @kolturra 

 

Sorry I have no idea about what the agent wise report is. but if you're working with power bi desktop/service for the report. then export as a PDF is possible.

For desktop:

05.PNG

For service:

06.PNG

I don't think it's able to export the pdf using DAX/M code. Probably the above 2 ways are the most easier way.

For the automatic download option, the product team has set about is. you can vote for this idea in the portal to bring it coming soon:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13422336-scheduled-export-of-a-re... 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Hi @v-diye-msft ,

 

Thanks for your reply.

 

In my PBIX file i have dashboard which has country wise analysis, i want to download PDF individual country wise like below.

 

INDIA.PDF

CANADA.PDF

USA.PDF

 

i was searching whether we can automate this task or not.

 

Thanks,
K Raghavender Rao

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.