Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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) ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |