Answered

Apply to each using Power BI button click

(0) Share

Report

Posted on by Werner_Otto

Hello, I have a small test dataset:

I want to use power automate, to loop through the emails, And send them a custom email using their name and email.
However when I run my flow I get this error:

To my understanding this means the data object power bi is sending through is "Null", or basically empty.
My flow:

My visual has the data linked:

Yet it seems that the data is not being pushed through?
I can however push through my user details that pressed the button.

When i check the input schema for the Power BI button press i notice this:

If these are the empty input parameter's, how do I go about to finding the problem to parse the data to my flow?

Any help would be appreciated.
Thank you for your time.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ChrisMendoza 425 on at

Like (0)

Report

@Werner_Otto- just to be sure, you've published your report to https://app.powerbi.com? Pretty sure you need Power BI Pro or better license to publish.

Was this reply helpful? Yes No
Werner_Otto 7 on at

Like (0)

Report

Hello @ChrisMendoza , yes thank you, that was the problem, once I uploaded the report to my workspace it could appropriately send the data through.

Was this reply helpful? Yes No
y3wan 17 on at

Like (0)

Report

Hi @Werner_Otto & @ChrisMendoza

I have a question about the Power Bi button discussed....It seems that it is delivering blank data for me, which result a similar NULL error messages when I tries to export the table to csv file.

Could the button only function properly without the table (Power BI) being published?

Was this reply helpful? Yes No
ChrisMendoza 425 on at

Like (0)

Report
@y3wan Hard to tell as you're not giving much detail into what has led to this result. CoPilot gave three possibilities:
Single Table Limitation: Currently, you can only run queries against Power BI that return a single table1. If you’re trying to get data from multiple tables, you might need to use two separate buttons, or find a way to encode your results (for example via CONCATENATEX) in Power BI and then decode them in Power Automate.
Data Type Issues: If the data type of the metrics and columns is not defined (General), it could cause problems with the values that you are passing to the Power Automate object.
Access and Permissions: If the flow is supposed to be triggered by different users, you need to share the flow in Power Automate with everyone that shall use it.
Possibly one of those reasons?

Was this reply helpful? Yes No