Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community Members,
I'm facing an issue with OData Feed connector. I'm using it to get data from D365 to Power BI. There are a few transformations done in the Query Editor. Earlier it was working fine but now when I try to apply the changes after removing a data transformation step(Filter Rows) it keeps on loading data again and again.
As in the image, it shows 84.7 MB but it will start loading from start.
Any suggestion please...
Thanks
Solved! Go to Solution.
I would not sort my data in Power Query - it is not necessary.
I would also use Table.Buffer in the second step to load the data only once.
How important is SalesChannelMap.Name to you? Is that something you could join in the data model rather than in a Power Query Merge (which is very expensive) ?
Are you able to post a sanitized version of the relevant piece of your Power Query code?
I would not sort my data in Power Query - it is not necessary.
I would also use Table.Buffer in the second step to load the data only once.
How important is SalesChannelMap.Name to you? Is that something you could join in the data model rather than in a Power Query Merge (which is very expensive) ?
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |