Forum Discussion

dean_rowntree's avatar
dean_rowntree
Regular Visitor
7 years ago

Difference between PowerBI and Powery Query in Excel with same data

Hello   I am trying to create a cumulative flow diagram in PowerBi, but my data is not giving me the results I expected. I recreated it in Power Query and got the result I expected.   Here is the...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI dean_rowntree,

 

I also not so sure for the internal calculation logic, maybe you can submit a support ticket to get better support from dev team.

 

Regards,

Xiaoxin Sheng

dean_rowntree's avatar
dean_rowntree
Regular Visitor
7 years ago

Thank you for the suggestion, I may try that if I can figure out how to do so.

  • sp8's avatar
    sp8
    Helper II
    6 years ago

    Did you ever figure this out? I'm having the same issue- I get 2000 lines when I run a query in Excel, but 100 lines when I copy and paste the query into PBI.