Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

ananunez

Data not showing in Power Bi

Submitted by on ‎05-19-2022 06:00 AM

Hi everybody, 

 

i have a issue withe my Power Bi, i have a DB in excel with columns, i imported to Power Bi but some columns are not showing any values, i check if all are in numberic values but the data doesn´t appear, i dont know what i missing on this, 

 

thanks, 

Status: Investigating

Hi @ananunez ,

 

By not displaying the data here, do you mean not displaying it in the Data view?Can you see this data in the query editor?
In your scenario, it seems the Excel was refreshed with some empty rows contained, while you didn't exclude those empty rows, so that the error throws out. Please open the report in Power BI Desktop and open Query Editor, then check the "Remove Blank Rows".

 

Please correct me if I have misunderstood your meaning.

 

Best Regards,
Community Support Team _ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎05-19-2022 10:18 PM
Status changed to: Investigating

Hi @ananunez ,

 

By not displaying the data here, do you mean not displaying it in the Data view?Can you see this data in the query editor?
In your scenario, it seems the Excel was refreshed with some empty rows contained, while you didn't exclude those empty rows, so that the error throws out. Please open the report in Power BI Desktop and open Query Editor, then check the "Remove Blank Rows".

 

Please correct me if I have misunderstood your meaning.

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses