Forum Discussion

lakshmi9228's avatar
lakshmi9228
Helper III
8 years ago

Restrict rows retrieved by query?

Hi, While uploading data from SQl server directly, few quantitative columns are missing in Power BI. Please let me know what to do to retrieve the data. Thanks
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

By "directly" are you saying you are using Direct Query?

  • lakshmi9228's avatar
    lakshmi9228
    Helper III
    8 years ago

    When using Direct query, I couldnt see few columns in power BI though it exists in SQL View

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Hi lakshmi9228,

       

      In your scenario, what kind of columns are missing? Could you please also share us some screenshots about your issue if possible?

       

      Thanks,
      Xi Jin.