Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Missing columns from SQL server view

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 column...
tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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?