Forum Discussion

arca123's avatar
arca123
Icon for Advocate I rankAdvocate I
2 years ago
Solved

PowerQuery results change after PBI report has been published

Hi! I encountered a very strange problem, and I wanted to find out if anyone has ever been affected by this problem, or if there is something I am doing wrong or missing. I have a table that has 'm...
  • jennratten's avatar
    2 years ago

    Hello - Power Query scripts in a report in desktop vs. when published should be exactly the same.  If you are seeing a difference then the two reports being compared are not actually the same and just look the same, so one of the below is happening:

    • The file did not successfully get published to the Power BI service therefore the versions being compared are not the same (one is an older version).
    • The report is getting published as a duplicate that looks like a report with the same name.  Perhaps there is a space at the end of the report name.  Or if one is a report with the semantic model and the other is a report with a live connection to a semantic model the the two reports can actually the same name but the end result is that they are not the same.
    • Power BI is not behaving as it should - you should submit a support ticket so Microsoft can further assist.