cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
afr Regular Visitor
Regular Visitor

Missing columns when connecting to SQL server view

Hi All, 

 

When I connect to the SQL server and I select the table I want to access, I see that there are 29 columns. However, when I load the table, I only have 20 columns. 

Any idea why?  

1 REPLY 1
Community Support Team
Community Support Team

Re: Missing columns when connecting to SQL server view

Hi @afr

 

Based on my test, i cannot reproduce the same issue. Check if the columns are the same both in Query Editor and Date view. Here are some posts for reference. 

 

https://community.powerbi.com/t5/Desktop/Power-BI-Missing-Data-in-Some-Columns-from-Local-SQL-Databa...

https://community.powerbi.com/t5/Desktop/Column-not-showing/td-p/374480

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.