Forum Discussion

ATREZISE's avatar
ATREZISE
Helper I
5 years ago
Solved

DataVerse Direct Query with field selector

Hi Everyone   I'm tring to connect to our dataverse environment using direct querty but only want to pull a limited number of fields in the hope that this will improve performance.   I've done th...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, ATREZISE 

    According to my test, the SELECT query selected the columns from the same data source.

    This is the original query:

     

    This is the query after “Remove column”:

     

    Although the query is a little bit different, but the table name after the “from” is the same.

    Therefore, I think you can create a table with fewer columns to connect with Power BI and check if you can get the same result as mine.

    Thank you very much!

    More info about the “View native query”

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, ATREZISE 

According to your description, you want to pull a limited number of fields into the Power BI when using the direct query, I think you can use the Power Query editor to achieve this. You can click on the “Transform data” when you connect to the data source and select the tables you want:

 

Then you can press on “Ctrl” to click the columns you want to remove, then select “Remove columns”:

 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.