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...
dean_rowntree's avatar
dean_rowntree
Regular Visitor
7 years ago

Thank you for the information, but I don't understand how the same code can produce different reults from the same source data, with the only difference being the application the code is executed in.

  • 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.