Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
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 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
What if you grant more premission to "Jack", say sysadmin, I'd guess it is lacking of permissiong to get the meta data information.
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
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?
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.
@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?
What's going on when specifying all the columns in a select query when connecting to the view?
That's pretty odd, what are the data types of those other 7 columns?
User | Count |
---|---|
116 | |
73 | |
60 | |
48 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |