Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

select flow - Inv No showing null

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.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    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.