Using SQL views in Power Query

AspiringPBIUser · ‎02-21-2023

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 · ‎02-21-2023

@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?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

AspiringPBIUser · ‎02-21-2023

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