Forum Discussion

Fantmas's avatar
Fantmas
Helper III
3 years ago

Table in PowerBI not reflected data in PowerQuery

Hi all,

 

I have updated a report in PowerBi desktop and I have blank value, by investing a bit I noticed that data display in Power Query and in the table is not the same see screenshot below :

Power Query :


Table in PowerBI Destkop :


Do you know how I can fix the issue,

Regards

Need Help

3 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    Hi Fantmas ,
    when loading the data to the data model, Power BI will determine its own sort order to optimize the storage. So you cannot not expect it to be similar to what you see in the query editor.
    So if the blank value is a problem for you, you must search for the reasons somewhere else.

    • Fantmas's avatar
      Fantmas
      Helper III
      3 years ago

      Hi,

      Yhank you for your feedback but I am confused as this coulmn is created in Power Query with a text.combine so the data should be the same

      if you can give me or someone in the forum to have a better understanding,

       

      Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi all, I'm also faceing the same problem. Eventually the edit I applied in power query were not reflected in my data table after the changes are applied.

    Image below is the one from power query, my withdrawal_status column should contain "yes" and "no" values and i did not apply any filtering or other steps afterwards.

     

    In my data table, only "No" values are available, and all the "Yes" values are replaced with "No". Refer image below.