Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Guys! Im having an issue for a while that I can not fix it.
I have a table below where a colun has some values. The values are either blank or appear a data for me.
When I go to transform data and replace blank for "DETACHED" for instace, all the information disappear of my table. check the step by step below
It also happens when I need to add a colum.
Thank you so much!!!!
Hi, @favlucas
Can you check that your values are exactly null? Is it possible that the blanks in your data aren't really nulls or blanks? They might be a non-printing character or space. In such cases, the above-mentioned steps will not work.
if its a space you need to put space in the value to replace the field.
Proud to be a Super User!
Hello guys, I will post another example that might be better to understand.
When I add a colum, as below, my table does not appear the data anymore;
Hi @rubayatyasmin thank you for your contribuition.
The issue is not related to replacing the blank on the field, this point aleady done.
The point is when I replace it, my table does not appear any information anymore, even with any filter.
Tray data source refresh after loading.
Proud to be a Super User!
does it mean refresh? then yes
Proud to be a Super User!
Hi @mlsx4
Actually this is a card, apart from the table just showing the quantity of itens that I have in this table.
Thank you for your message, but I dont think this is the issue.
Okey @favlucas . And have you checked any possible filter that could be active?
And if you start now constructing another table in a empty page, do you have the same problem?
Also, I suppose you are using a measure or a later step to rename all specialties... Have you checked it too?
Thank you @mlsx4
I checked the filters and it is not the case as well.
When I excluded the table and created other, some informations that are related to other tables comes in blank for me, even though the relations among the tables are active. please, check below:
The columns above that are in blank are client name and specialty name, respectively.
Another thing, is the replaced id the link key with the table specialty? If so, public specialty should have replaced it too
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |