Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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.
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