March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
Solved! Go to 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.
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
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
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.
@sanjanarama ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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?
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.
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?
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.
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.
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.
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 :
Best Regards,
Winniz
@v-kkf-msft
thank you, i was able to connect to import connection and flow has succedded.
worked perfectly.!!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
84 | |
82 | |
74 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |