Forum Discussion

smjzahid's avatar
smjzahid
Icon for Helper V rankHelper V
4 years ago

Dataflow displays Fact column value but PBI Desktop Do

I have a dataflow which connects to sharepoint (excel file) and use few merge steps to combine and prepare the data for analysis. The dataflow works fine and refresh okay. I  have tracked all the (Applied Steps) in dataflow (PBI Service) and the columns named Period Expenditure is displaying values for column named Period Number filtered on 2022.03

 

 

 

The second image is from PBI Desktop, do not know why its showing 0.00 whereas in dataflow it does show the correct value (first image)

 

ANy  hint or idea is appreciated, Thanks 

Show and Tell
Tips and Tricks

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi smjzahid 

    Thanks for reaching out to us.

    >>The second image is from PBI Desktop, do not know why its showing 0.00 whereas in dataflow it does show the correct value (first image)

    after you set date filter in dataflow, then click refresh now on the Service like below,

    then go to Power BI Desktop, click refresh, will the values become correct?

     

    In my side, I first click refresh now, then click refresh in Power BI Desktop, this works fine.

     

    Best Regards,

    Community Support Team _Tang

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