Forum Discussion
jjwerkman
6 years agoRegular Visitor
Query changes very slow after expanding table in column
Hope someone can give me the right tip. Like the most of the users I'm also a newby 😛 but learning fast, with this great tool. I've added an OData feed which rans fine. In the fetched tables are...
jjwerkman
6 years agoRegular Visitor
Thanks for the replies.
So, it is better to first expand all columns, instead of selecting the colums which are only needed?
- v-juanli-msft6 years agoCommunity Support
Hi jjwerkman
Before expanding columns, check columns from the drop-down list,
then expand, after this, you could filter rows and columns in power query,
finally, close &&apply into data model.
Best Regards
Maggie