power automate

23 Topics

Update dataset refresh timing into excel using power automate
Can anyone help me do this? Update dataset refresh timing into excel using power automate. when dataset refreshes in power bi service workspace the refresh time should get updated in excel sheet in front of dataset name
Solved
Anonymous
1 year ago Place Service
4.9KViews
0likes
5Comments
Help Removing TOPN
Hello, I am using the following query from performance analyzer to use in a Power Automated flow. Can anyone help re-write this dax so that it does not include TOPN? // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({TRUE}, 'Trainee Skill Completions (History)'[Skill Is Active]) VAR __DS0FilterTable2 = TREATAS({TRUE}, 'Trainee Skill Completions (History)'[Assignement Active (hide)]) VAR __DS0FilterTable3 = TREATAS({"TES"}, 'Users (Trainees)'[Division]) VAR __DS0Core = SUMMARIZECOLUMNS( 'Users (Trainees)'[Division], 'Users (Trainees)'[Office], 'Users (Trainees)'[Department], 'Users (Trainees)'[User ID], 'Users (Trainees)'[User Display Name], 'Skills'[Skill Product Line (BU)], 'Skills'[Skill Platform / Group], 'Skills'[Skill Subgroup], 'Skills'[Skill Category], 'Skills'[Skill Title], 'Skills'[Skill ID], 'FY Baseline (hide)'[Baseline Completion Rate], 'Trainee Skill Assignments'[Current Skill Completion Rate], 'Trainee Skill Assignments'[FY Target Percent], 'Trainee Skill Assignments'[FY Goal Status], 'Trainee Skill Assignments'[FY Target Goal Group], 'Trainee Skill Assignments'[Baseline Tasks Required to Goal], 'Trainee Skill Assignments'[Remaining Tasks Required to Certify], 'Trainee Skill Assignments'[Skill Level After Goal], __DS0FilterTable, __DS0FilterTable2, __DS0FilterTable3, "Number_of_Requested_Tasks", 'Task Measures'[Number of Requested Tasks], "Remaining_Mandatory_Tasks", 'Task Measures'[Remaining Mandatory Tasks] ) VAR __DS0PrimaryWindowed = TOPN( 501, __DS0Core, 'Skills'[Skill Product Line (BU)], 1, 'Users (Trainees)'[Division], 1, 'Users (Trainees)'[Office], 1, 'Users (Trainees)'[Department], 1, 'Users (Trainees)'[User ID], 1, 'Users (Trainees)'[User Display Name], 1, 'Skills'[Skill Platform / Group], 1, 'Skills'[Skill Subgroup], 1, 'Skills'[Skill Category], 1, 'Skills'[Skill Title], 1, 'Skills'[Skill ID], 1, 'FY Baseline (hide)'[Baseline Completion Rate], 1, 'Trainee Skill Assignments'[Current Skill Completion Rate], 1, 'Trainee Skill Assignments'[FY Target Percent], 1, 'Trainee Skill Assignments'[FY Goal Status], 1, 'Trainee Skill Assignments'[FY Target Goal Group], 1, 'Trainee Skill Assignments'[Baseline Tasks Required to Goal], 1, 'Trainee Skill Assignments'[Remaining Tasks Required to Certify], 1, 'Trainee Skill Assignments'[Skill Level After Goal], 1 ) EVALUATE __DS0PrimaryWindowed
Solved
cinderelly678
2 years ago Place DAX Commands and Tips
1.4KViews
0likes
3Comments
Power 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, Simon
SimonSeez2
2 years ago Place Report Server
5.5KViews
2likes
6Comments
Envio 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 ayuda
MarcelinoPumar
3 years ago Place Report Server
798Views
0likes
3Comments
Send 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!
Solved
katmaher_1
3 years ago Place Report Server
14KViews
0likes
5Comments
get a notification on the same Power BI (Pro version) report page (not an email notification)
Imagin we have a Power BI report that an end user uses and when the data source modifies it refreshes a PBI dataset using an automatic flow. As we use PBI Pro version we have a 8 time limit per 24 hrs but we want to set up a notification on the same rpoert page for any user (not PBI DS owner) like a card visual that alerts him when the 8 times limit reached per cycle. Again, I reiterate it that we dont want a TEMAS / EMAIL or anyother instruments to get notification because the end user (not DS owner) must instantly notified on the same report page when the maximum no. of refreshes reached. I would appreciate your help
Solved
Anonymous
3 years ago Place Service
1.2KViews
0likes
5Comments
Automatizar el envio de un reporte en formato PDF por correo.
Hola muy buenas tardes, queria consultar si teniendo cuenta premium personal es posible utilizar Power Automate para automatizar la exportación de un reporte a un correo de Outlook en formato PDF. Gracias
caco021
3 years ago Place Report Server
662Views
0likes
1Comment
Export 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!
Solved
Anonymous
3 years ago Place Report Server
666Views
0likes
1Comment
Text filter
Hi everyone! sorry if my question is a dumb one.... I am almost sure what I am asking is impossible. 🙂 I have a requirement where I would like to store all the searches in a TEXT FILTER visualization that have no results. The idea is for a KNOWLEDGE BASE and I would like to understand what are the users searching with no results so I can create that new content. Is it possible to somehow use the string used in TEXT FILTER in a measure or something in order to trigger somehow a flow with Power Automate?
alavanka
3 years ago Place DAX Commands and Tips
502Views
0likes
1Comment
Power Automate is not show the visualization
Does anyone could advise this?
otiecanna
3 years ago Place Desktop
646Views
0likes
2Comments