Forum Discussion
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 columns which also have tables in the fields. When I expand this table in separate columns the 'applying query changes' is very, very, very slow.
Am I doing something wrong, possible I must solve this with DAX in the Table View and not in the Query itself? Can't find the right DAX commands. Or is this a limitation of the OData feed (supplier)?
4 Replies
Hi jjwerkman
You need to expand the tables before you load the model, therefore you can not do it with DAX, OData feeds might be restricted so you don't pull too much data at once, also your machine might be too slow, try maybe dataflows ( it might be faster )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInHi jjwerkman
After expanding columns, filter out columns/rows which are not needed,
then close&&apply into data model,
you could create measures/columns with DAX in Modeling.
If you have problem creating DAX formula, please share some example so we can help you further.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks for the replies.
So, it is better to first expand all columns, instead of selecting the colums which are only needed?
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
