Forum Discussion
DataVerse Direct Query with field selector
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.
ah...so are you saying that only the final SELECT query is executed?
The Navigation step looks like this...
However the next step (which removes the columns) only has the required columns...interesting though that it is selecting from a different source.
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.