select flow - Inv No showing null

[kaslvi]

Hi everyone. I am fairly new to Power Automate

I came across a problem when running the action Select for Power BI Reports in the Flows. When the flows run successfully, the output of Inv No shows null .

Test Flow - embed a power bi report data 

1.Total sales by date dax query

2.Select

i've got value for customer,item and date  but qty,inv no and amount showing null.

i've tried customer,item following expression but Inv No shows null.

[Anonymous]

Hi, @kaslvi 

You can try checking the following:

First, you need to check if your data source is empty under the current query statement. You can do this using Power BI Desktop.

Make sure that the current DAX query statement is correct, and that the current DAX query statement is correct, and that there is a non-null output in the dataset using a method such as Inv No.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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