Forum Discussion

lakshmi9228's avatar
lakshmi9228
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity Champion
8 years ago

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

lakshmi9228's avatar
lakshmi9228
Icon for Helper III rankHelper 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
    Icon for Solution Sage rankSolution 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.