power automate
12 TopicsPower BI Report Server and Power Automate
Hello Team, I've got this business request where I have to share page of a Power BI Report to several users via email. My report is currently hosted on Power BI Report Server as my organisation uses an on-premise environment. Can anyone guide me or point me in the direction of an online tutorial on how I can achieve this using Power Automate? Best Regards, Simon5.5KViews2likes6CommentsEnvio Automatico de Informes de Power BI con distintas variables
Buenos dias Actualmente tengo preparado un informe en power BI, ese informes lo quiero enviar a una lista de distribución de 10 personas que la tengo definida dentro del informe. Lo que pasa es que a cada persona le quiero enviar el informe filtrado por una segmentación existente en el informe, es decir serian 10 informes con los mismos objetos y tablas, pero cada uno mostrando datos diferentes. Básicamente lo que quiero no es que duplicar 10 veces ese informe y adaptarlo a cada usuario, sino que se use el mismo cambiando un campo ¿Desde power automate puedo operar los valores de la segmentación o de los filtros de power BI? ¿Cómo se haría? Muchas gracias por vuestra ayuda795Views0likes3CommentsSend Email to Report Users when Report is Refreshed
I have a report that willl be shared with ~300 users, but the user list will change as people enter/leave the company. I am trying to find a way to send an email via Outlook to all of the report users when the dataset is refreshed. Given the irregular nature of users being added to the report the subcription button does not really work that well to acomplish my goal. Is there a way to set up an email that is triggered on a PowerBI refresh using PowerAutomate, or is there a way to subcribe every report user to the Subcription feature in PowerBI? Thank you and looking forward to learning new ideas/solutions!Solved14KViews0likes5CommentsExport paginated report from on-premise report server
Hi all, I am trying to automate the export of a paginated report to pdf. The reports are stored locally on an on-prem report server and i have a gateway to connect to power automate. My report database is a sql database and i can connect to it via the SQL connector in power automate. But i am struggling with "finding" the paginated report and make it available for the "export paginated report to pdf"-action. I am happy about any help, still very new in the power bi / power automate universe. Thanks!Solved664Views0likes1CommentPower BI Subscription Email image preview size
Hello Folks, We have a requirement for a daily report to be sent as a PDF attachment and also have a "readable" image preview. No matter how I size the page, I still end up with a huge Microsoft logo and a smaller image preview with lot of email space wasted. I'm aware that clicking on the image actually opens the full report screenshot, a link to report can be given and the PDF attachment is pretty handy too. However, our users are pretty stubborn that the image quality should be good. I tried Power Automate but couldn't acheive results as we have PPU license. My questions: 1. I tried to send Pagniated report version via Power Automate to deliver image preview but it doesn't seem to be supported. Am I missing something? 2. I can not seem to find any settings to increase the image preview size or get rid of Microsoft logos. Can someone please help? Thank you!1.5KViews1like1CommentEmail subscription on PBI report server
Hi Team, I am working on PBI report server. there is a requirement of sending reports in user's mail box. As per my knowledge currently email subscription is not available on PBI report server. Could any one suggest if any work around is possible using Power automate and PBI report server? Thanks Rajnish ChoudharySolved802Views0likes1CommentAre there a way to prompt confirm before clicking the Power Automate button on Power Bi Service?
Hi everyone, I need help finding a way to prompt confirm before clicking the Power Automate button on Power Bi Service. The button is very sensitive, and I want to have a way to protect users from accidentally clicking on it because it will send out many emails to many people if they forget to filter the table. I already set the limit to 5, but it's not the right solution. Thank you for your help in advance.1KViews0likes2CommentsPage breaks excel export while exported from power automate
I have developed power bi report builder report and have conditional page breaks. When exported to pdf it should have page breaks and when exported to excel it should not. It works fine when I run and download report manully from services. When I run the report through power automate and generate automated reports page break does not work in excel export. Please advise1.1KViews0likes3CommentsState of paginated reports workload in capacity [...] is Faulted
Hello community, we're using power automate to refresh a paginated report which is loaded in power bi service within an a4 capacity workspace. Since 2 months we got the following error and I can't find any specific solution for this error: "code": "PaginatedReporWorkloadFaultedOnCapacity", "message": "State of paginated reports workload in capacity [some key] is Faulted." This error is shown in power automate in the step of "export file to paginated power bi report" Could someone help?Solved675Views0likes1Comment