Missing columns from SQL server view

[Anonymous]

Hi community,  I'm new to MSPBI so would you be able to help me out please.    I've made a connection to one of our SQL Servers and pull in the defintion from a view.  But only a subset of the columns are showing; i.e. the view def. has 10 columns but PBI is only showing 3 of them.   Any ideas what I'm missing?

thanks

Mark

[DineshPriyankar]

Hi,

Anyone has a solution for this? I started experiencing the same with May 2017.

If you need a sample code, I have written a simple code to check this against AdventureWorks2014 database, see this: http://dinesql.blogspot.com/2017/06/power-bi-does-not-show-all-columns-in-sql-server-view.html

I might have made a mistake or missing something, appreciate if someone can help me on this.

Regards

Dinesh

[Eric_Zhang]

---

@DineshPriyankar wrote:

Hi,

Anyone has a solution for this? I started experiencing the same with May 2017.

If you need a sample code, I have written a simple code to check this against AdventureWorks2014 database, see this: http://dinesql.blogspot.com/2017/06/power-bi-does-not-show-all-columns-in-sql-server-view.html

I might have made a mistake or missing something, appreciate if someone can help me on this.

Regards

Dinesh

---

@DineshPriyankar

What if you grant more premission to "Jack", say sysadmin, I'd guess it is lacking of permissiong to get the meta data information.

[DineshPriyankar]

Hi,

Thanks for the reply. I made him as db_owner and no luck. Then tried again after making him as sysadmin, same result. Can it be related to database schema?

Thanks

[tringuyenminh92]

Hi @Anonymous,

Could you please share your details sql of view, have u tried alter view and execute details of view again. then connect to viev?

[Anonymous]

hi some views work ok.   But this one and a few others of a similar defintion don't.   There's nothing unusual about them, just standard views on stadnard tables.

[Eric_Zhang]

@Anonymous

Would it be ok by re-creating the views? Would the same view always doesn't work when re-import in Power BI?

Is it possbile to post the View and underlying table creation DDL?

[Eric_Zhang]

What's going on when specifying all the columns in a select query when connecting to the view?

[Greg_Deckler]

That's pretty odd, what are the data types of those other 7 columns?