Restrict rows retrieved by query?

[lakshmi9228]

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

[Greg_Deckler]

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

[lakshmi9228]

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

[v-xjiin-msft]

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.

[lakshmi9228]

Hi, 

While uploading data from SQL directly to power BI, few quantity columns are missing.

Please let me know what to do to retreive those columns.

Thanks