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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sanjanarama
Resolver I
Resolver I

how to send emails to certain recipients

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?


sanjanarama_0-1657527917800.png

 

2 ACCEPTED SOLUTIONS

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.

vkkfmsft_0-1658306617017.png

vkkfmsft_1-1658306661602.png

vkkfmsft_2-1658306694311.png

 

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.

View solution in original post

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 :

 

vkkfmsft_0-1659505400069.png

 

Best Regards,
Winniz

View solution in original post

12 REPLIES 12
willjoe2442
Helper I
Helper I

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
Community Support
Community Support

Hi @sanjanarama ,

 

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

 

vkkfmsft_0-1657764462269.png

 

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
Super User
Super User

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

Appreciate your Kudos.

QuartercustomerfamilydescriptionInvoice priceRPUNetPriceCostMargin
2021Q4New InfoFamily one1234160.00-4.33333155.66678150.6667
2021Q4New InfoFamily one1234164.00-1015410134
2022Q1New InfoFamily one1234160.00-915135111
2022Q1New InfoFamily one1234164.00-58.0467105.953342100.9533
2022Q2New InfoFamily one1234160.00-8.62993151.370118151.3701
2022Q2New InfoFamily one1234164.00-5.97458158.025414100.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?

 

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.

vkkfmsft_0-1658306617017.png

vkkfmsft_1-1658306661602.png

vkkfmsft_2-1658306694311.png

 

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.

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

 

sanjanarama_0-1658730943194.png

sanjanarama_1-1658731133264.png

 

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

Hi @sanjanarama ,

 

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

 

vkkfmsft_1-1658906359115.png

 

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.

 

vkkfmsft_0-1658906284191.png

 

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.

@v-kkf-msft 

sanjanarama_0-1659336146790.png

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

Hi @sanjanarama ,

 

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

 

vkkfmsft_0-1659345513079.png

 

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]

vkkfmsft_1-1659345683172.png


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'])"

vkkfmsft_2-1659346134164.png


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

 

vkkfmsft_3-1659346195286.png

 

 

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.

 

 

 

 

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."}}]}}}

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 :

 

vkkfmsft_0-1659505400069.png

 

Best Regards,
Winniz

@v-kkf-msft 

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

sanjanarama_0-1659525500201.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors