Help General Question

[POWER_MI]

Hi 

I have somes questions about Power BI

I need to know for example when you will have KPI results on table 

for example KPI row project 

Red color 15 row on results 

...on the report of dashboard 

is it possible to export 15 row on excel.

Also i have customers asking about power BI licence :

I need to know if i will have 1 account developper licence and there will be 150 users just to consult all report without change or update.

How many licences to ask ?

i understood on microsfot web site it's 150 ??

Also are there some tools on power bi to send email with report excel " means for example 

for engener having 14 row KPI red 

power bi will export the 

[v-rzhou-msft]

Hi @POWER_MI 

I think you build a table visual and flag some values in red. Now you want to export the Rows in Red in Excel.

You can't export only red directly, but you can use filter function.

I build a sample to have a test. In my test, I make values <100 in Red.

Now set Filters  value column: 

Then you export Summarized data in Excel.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[POWER_MI]

Hi Rico,

thanks a lot for answer.

The asking is for example in your table when you have KPI

USER : I

Value: 60

is it possible to example just the value 60 of this windows User I and value 60.

it's very special

thanks for help

[v-rzhou-msft]

Hi @POWER_MI 

My origanal Table is as below.

If you only want to see User =1 and Value = 60, you may use filter.

User column show values = I , Value column show values = 60.(If you have multipy USER = 60 and multipy Value =60)

Result:

If this reply still couldn't help you solve your problem, please show me more details about your data model and tell me the result you want. This may make it easier for me to understand.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[POWER_MI]

Hi Rico,

thanks for your feeed back.

the asking is not to export excel table of dashbord, the objectif is when you select the row :

user : I

value : 60

when we will click on this 60 we will export the 60 Rows of KPI that not OK

for example 60 rows we click on the case I60 and we will export all row 60

for example for

Row : D

Value : 90

we will export on excel file the 90 ligne you see

because for our activité it's KPI means

KPI

PROJECT 1 25 (KO)

PROJECT 2 15

PROJECT 3 13

PROJECT 4 28

So to arrive to this table we will selection all values and see who have KO KPI and OK kpi

in this case

for example for Red KPI means KO Kpi when we will click on

Row :project 2

Values : 15

in this case we will export 15 row on exce

[POWER_MI]

Hi Rico,

I have make here one example with Data

you will find enclosed the file used to define project.

the excel file is source

On power BI this is dashboard

this is mesure that y add on poweer BI

Number of STATUS for OK

CALCULATE(COUNTA('Tableau1'[STATUS]), 'Tableau1'[STATUS] IN { "OK" })

the asking is when i will select for example box with Nombre de STATUS pour OK = 3 ( row "To do 1"/"OP1"/status "KO" ) i will export the 3 line of this box means the results 3

are number but will also export this concerned rows 3 with excel rows not just number 3.

[v-rzhou-msft]

Hi @POWER_MI 

I try to export the table visual you show to me.

However we can't export the values directly by the visual you show to me.

I build a new table visual and filter it by the rows(Measure) you show to me. When I select 3 ( row "To do 1"/"OP1"/status "KO" ), visual2 will be filtered by Action and Status, so it shows the result: Status = KO.

Even I select 3 ( row "To do 1"/"OP1"/status "OK" ), it will only show the aggregation result.(Only one row)

Currently, you may not be able to export the result like your screenshot. 

Power BI will aggregate the same rows and show one row in table visual.

To achieve your goal, I add an index column in data model(Power Query Editor - Add column- index) and build a new table visual to filter visual 2.

New Table:

New visual：

In this visual, select 3( row "To do 1"/"OP1"/status "OK" ) ,and export visual 2.

We can't filter Status OK by select Status = KO in other visuals.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[POWER_MI]

Hi Rico

thanks for this answer. Can you please explaine how you add Index on power BI.

Also i have another question is it possible to send this excel file exported with email directly ?

Not .csv but excel file

to explain more

the table explained is activity to do by some member of team and actions

so the action which is KO we will export them and send it to person to work

is it possible to make it automatiquly export excel ( all rows KO) and send it by mail ?

thanks

[v-rzhou-msft]

Hi @POWER_MI 

You may refer to this blog to add an index column in your data model.

(Click Transform data in Home Tab —— Index column in Add column Tab)

Blog:  Add an Index Column

If you want an automate workflow in export and send email to specify team or user, you may try Power Automate.

Here is the app : Power Automate

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[POWER_MI]

Good morning Rico,

Thanks a lot for your answer. I have seen that Power automate can do this but the mistakes that it's not free.

Big probleme because it will payed for all mail to send.

Also for excel export are there any script to write to this automatiquely ?

Means that on the power BI we will select the rows needed and will be sent automatiquely?

thanks

[v-rzhou-msft]

Hi @POWER_MI 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou 

[v-rzhou-msft]

Hi @POWER_MI 

Without Power automate, I think you may try RLS to set a limit on the report to show teammates the values you want them see and share the report to them and they can export in Excel by themselves.

Here are some Blogs.

Blog1: Row-level security (RLS) with Power BI

Blog2: Roles on pbix

Blog3: Dynamic Row Level Security with Power BI Made Simple

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[v-rzhou-msft]

Hi @POWER_MI 

You can't export 15 row in Red Color in Kpi visuals.

You may refer to this blog for export data from dashboard or reports.

Blog:Export data from a visual

Do you have Premium lincense? If you have Premium lincense you can share your pbix file to free users.

You may refer to the link below to calculate a more reasonable way to buy pro and premium for 150 users.

Blog:Power BI Premium calculator

And if your want to power bi to send an email you may try subscribe function or alerts function.

Blog:Data alerts in the Power BI service

Blog:Subscribe yourself and others to reports and dashboards in the Power BI service

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[POWER_MI]

Hello Help

thanks a lot for this answer.

You need to say that it's impossible to :

for example if you have KPI red color

your click on this one and export this red KPI on excek file ?

are there other solution to do it ?

thanks