cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carol_mar
Helper I
Helper I

excel table import values null

Hello, 

I imported an excel table and everything looked as it went correct. But when I click on the table there are only the name of te column and no data.

carol_mar_1-1610612609997.png

 

Same as when I try to make a relationship with another table, it doesn't give me any error but it actually doesn't do anything. 

carol_mar_0-1610612578034.png

carol_mar_2-1610612626160.png

Does anyone have a reason for that? thank you! @PBIComm 

1 ACCEPTED SOLUTION
MFelix
Super User III
Super User III

Hi @carol_mar ,

 

Go to the query editor and check if the final table is with null values or with data on it:

 

MFelix_0-1610797743175.png

 

If the query editor does not show any values also try to redo the import of the excel file.

 

Regarding the second part of your question since you don't have any values on the table although the connection is made it will no return nothing since the table is empty.

 

If this does not work can you tell what is the version you are using and if possible share a sample file?

 

You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User III
Super User III

Hi @carol_mar ,

 

Go to the query editor and check if the final table is with null values or with data on it:

 

MFelix_0-1610797743175.png

 

If the query editor does not show any values also try to redo the import of the excel file.

 

Regarding the second part of your question since you don't have any values on the table although the connection is made it will no return nothing since the table is empty.

 

If this does not work can you tell what is the version you are using and if possible share a sample file?

 

You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

MFelix
Super User III
Super User III

Hi @carol_mar ,

 

Taking into account the information you have shared with me, go to the query editor and filter out all the null.

 

When the table is transformed into the final version it automatically sorts the value by the first column so the null come in first so it appear has the table is all null since it only uses the top N to do the relationships preview.

 

So if you filter out all the null from one of the columns that you now must have values the lines that aren't to be consider will not be uploaded and your model will work properly.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.