Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Fantmas
Helper III
Helper III

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 :

Fantmas_1-1673106039333.png


Table in PowerBI Destkop :

Fantmas_2-1673106050134.png


Do you know how I can fix the issue,

Regards

3 REPLIES 3
s_maryam
Regular Visitor

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.

 

s_maryam_0-1694606018915.png

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

s_maryam_1-1694606195639.png

 

 

ImkeF
Community Champion
Community Champion

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.