cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tkashanatti Frequent Visitor
Frequent Visitor

How to upload blank cell on Power BI Desktop without any errors?

Hi Team 

 

I am trying to upload data that has blank cells in a column.  It shows that the row have errors. 

I tried using "isblank" option and I get the error IF not recognized.

 

Is there anyway to upload the data without any errors?

 

Thank You

Tahemin Afsha

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to upload blank cell on Power BI Desktop without any errors?

Hi @tkashanatti

One workaround is to replace the error with "null",

6.png

 

7.png

 

Then "Close&&Apply", in the Data view, "null" shows as blank

8.png

There is a similar thread, it seems like your case, could you check the final reply to see if it helps you?

https://community.powerbi.com/t5/Desktop/How-to-Remove-Error-in-Date-Field/td-p/347460/page/2

 

Best Regards

Maggie

3 REPLIES 3
Community Support Team
Community Support Team

Re: How to upload blank cell on Power BI Desktop without any errors?

Hi @tkashanatti

"I tried using "isblank" option and I get the error IF not recognized."

Do you mean you use DAX function "ISBLANK" and "IF" function?

 

If only the blank cells show errors, other cells are correct, you could go to Queries Editor->Replace Errors(Replace error with blank)

Reference: Power BI Pro Tip: Dealing with errors when reading Excel files

 

If you are not in the scenario above, please let me know more details, a scennshot or an example table (with columns show error in power bi) is prefered for analysis.

 

Best Regards

Maggie

tkashanatti Frequent Visitor
Frequent Visitor

Re: How to upload blank cell on Power BI Desktop without any errors?

Thanks for the response.

 

When I right click and select "replace  error", it asks for a value. and when I keep it blank. It doesn't accpet it. 

 

Is there any other navigation option that can do this operation to replace errors with blank?

 

Thank You

Community Support Team
Community Support Team

Re: How to upload blank cell on Power BI Desktop without any errors?

Hi @tkashanatti

One workaround is to replace the error with "null",

6.png

 

7.png

 

Then "Close&&Apply", in the Data view, "null" shows as blank

8.png

There is a similar thread, it seems like your case, could you check the final reply to see if it helps you?

https://community.powerbi.com/t5/Desktop/How-to-Remove-Error-in-Date-Field/td-p/347460/page/2

 

Best Regards

Maggie

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 263 members 2,868 guests
Please welcome our newest community members: