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

Get 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

Reply
favlucas
Frequent Visitor

Table becoming blank after transforming data

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!!!!step 1 - how is my tablestep 1 - how is my tablestep 2step 2step 3step 3step 4 - replacing valuesstep 4 - replacing valuesstep 5step 5step 6 - how my table is after updatestep 6 - how my table is after update

 

11 REPLIES 11
rubayatyasmin
Super User
Super User

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.

 

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

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;

My table before adding a columnMy table before adding a columnI click on transform dataI click on transform dataselect the tableselect the tablethen I click on add columnn based on delivery data, to show me the  name of the daythen I click on add columnn based on delivery data, to show me the name of the daythis is my database after that, everything is right so farthis is my database after that, everything is right so farthen, when I click on close and apply and go back to my table, every information is gonethen, when I click on close and apply and go back to my table, every information is gone

 

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. 

 

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


@rubayatyasmin you mean this button? 

favlucas_0-1689772207633.png

 

does it mean refresh? then yes

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


favlucas
Frequent Visitor

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:

favlucas_1-1689768886510.png

favlucas_2-1689768952109.png

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

mlsx4
Super User
Super User

Hi @favlucas 

 

You have some strange column which is shown (in blank). May the problem come from it?

mlsx4_0-1689766840806.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.