how to send emails to certain recipients

[sanjanarama]

Can we send emails - once in a day.
for utilization more than 10000 ? and in the email all the data like school name and allocations?

[v-kkf-msft · Accepted solution]

Hi @sanjanarama ,

If you have Premium capacity and your [Cost] is a column, then you can use Power Automate to subscribe the report. For more information, please refer to: Filter & Email Power BI Report pages using Power Automate & Excel 

Here is the sample flow I created.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[willjoe2442]

How do I send an email to a specific address?
Always send from a different address
On your computer, open Gmail.
In the top right, click Settings. See all settings.
Click the Accounts and import or Accounts tab.
In the "Send mail as" section to the right of the address you want to use, click Make default.

Regards,

Will

[v-kkf-msft]

Hi @sanjanarama ,

You can filter directly in the filter pane and then subscribe the report on Service.

If you only want to filter when sending emails, then you can use Power Automate to subscribe to report and then set up report level filter.

Export and email a Power BI report with Power Automate 

Reports - Export To File In Group 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sanjanarama ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[sanjanarama]

Quarter	customer	family	description	Invoice price	RPU	NetPrice	Cost	Margin
2021Q4	New Info	Family one	1234	160.00	-4.33333	155.6667	8	150.6667
2021Q4	New Info	Family one	1234	164.00	-10	154	10	134
2022Q1	New Info	Family one	1234	160.00	-9	151	35	111
2022Q1	New Info	Family one	1234	164.00	-58.0467	105.9533	42	100.9533
2022Q2	New Info	Family one	1234	160.00	-8.62993	151.3701	18	151.3701
2022Q2	New Info	Family one	1234	164.00	-5.97458	158.0254	14	100.0254

@v-kkf-msft
@amitchandak 
 i have this table in powerbi as table visual.
use case is i need to send an auto trigger email daily attaching records for which cost is >10?

[v-kkf-msft · Accepted solution]

Hi @sanjanarama ,

If you have Premium capacity and your [Cost] is a column, then you can use Power Automate to subscribe the report. For more information, please refer to: Filter & Email Power BI Report pages using Power Automate & Excel 

Here is the sample flow I created.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sanjanarama]

thank you @v-kkf-msft  i was able to add subsciption.
I have three questions
1. currently email is received with my email ID as i created flow, is there anywhere to change to different sender ID?
2. if you see my email here, i have received it as a normal file rather than a PDF format file as an attachment

 

3. how to add condition that send email only when at at least one record is present in table?

[v-kkf-msft]

Hi @sanjanarama ,

1. Please change or add other emails in the recipients of the email.

2. Based on my test, after downloading and opening the attachment it shows the following PDF file. Do you have special software installed to open PDF files? Or use a browser to open it.

3. Currently, we cannot achieve this condition, because we cannot get the number of records in the visual.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sanjanarama]

@v-kkf-msft 

Can we use query against dataset and get count of rows? if count is more than 1 then only send email to recepients ?

[v-kkf-msft]

Hi @sanjanarama ,

Great! This is a good idea. I test it, and we need to add the following steps to the flow.

For the second step, I copied it from Desktop's Performance analyzer, which filters rows with Cost column values greater than 10.

DEFINE
  VAR __DS0FilterTable = 
    FILTER(KEEPFILTERS(VALUES('Data'[Cost])), 'Data'[Cost] > 10)

  VAR __DS0Core = 
    CALCULATETABLE(
      DISTINCT('Data'[Cost]),
      KEEPFILTERS(__DS0FilterTable)
    )

  VAR __DS0PrimaryWindowed = 
    TOPN(501, __DS0Core, 'Data'[Cost], 1)

EVALUATE
  __DS0PrimaryWindowed

ORDER BY
  'Data'[Cost]

Then in the Compose step, the following code is used to calculate the number of rows output in the second step.

"@length(outputs('Run_a_query_against_a_dataset')?['body/firstTableRows'])"

If the value is greater than or equal to 1, export the report and send an email.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

[sanjanarama]

Wonderful !!!
I tried , 
I have this error at step 2 --"run query against dataset"


{"error":{"code":"DatasetExecuteQueries_DatasetNotAllowed","pbi.error":{"code":"DatasetExecuteQueries_DatasetNotAllowed","parameters":{},"details":[{"code":"DetailsMessage","detail":{"type":1,"value":"The dataset 'a1becaXXXXXXXXXXX' is a model hosted in Azure Analysis Services or SQL Server Analysis Services using On-Premise Gateway, which is not allowed."}}]}}}

[v-kkf-msft · Accepted solution]

Hi @sanjanarama ,

Is your data source Azure AS or are you using live connection mode to connect to SSAS?

Unfortunately this is a known limitation. Maybe you have to change the data source or the connection mode.

Datasets - Execute Queries In Group :

Best Regards,
Winniz

[sanjanarama]

@v-kkf-msft 

thank you, i was able to connect to import connection and flow has succedded.
worked perfectly.!!!