Restrict rows retrieved by query?

lakshmi9228 · ‎05-07-2018

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 · ‎05-07-2018

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

lakshmi9228 · ‎05-07-2018

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

v-xjiin-msft · ‎05-07-2018

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 · ‎05-07-2018

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

Helpful resources