Using SQL views in Power Query

[AspiringPBIUser]

Hi All,

I have an SQL view in my database that I can select in power query, however it only retrieves the first column and not the rest fo the table. Is there a fix for this or am I doing something incorrectly? 

Many thanks

[Greg_Deckler]

@AspiringPBIUser I use SQL views in Power Query all the time and do not have that kind of issue. Any more details you can provide?

[AspiringPBIUser]

Hi @Greg_Deckler so I have a view with 3 columns, each column is a calculation based on the same table but with different filter criteria. I have no issue with rows, as I have gotten all 3 in one column and they then all display, I'm just confused about why all  the columns are not showing, it's weird