Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am using PowerBI to read from MS Project Online (Office365) though an oData connection
Building a model is unbelievably slow.
I don't think it's a firewall/proxy bottleneck, but rather the way that PowerBI is designed to work. I'm hoping that there are some secret tips which someone will share, to solving this problem.
Now if I do the exact same with MS Excel, accessing MS PRoject online from an oData connection, the entire process takes under a minute... hence my thought the issue lies within PowerBI.
Is this really the best I can hope for?
Hi @Netrelemo
did you solve your problem?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @Netrelemo ,
How about using Data flow?
I don't think a re-engineering a whole data flow to build a model is a sustainable solution.
Hi,
i think this tips from Chris Webb could help you, to improve the performance.
https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
If PowerBI was querying multiple times, it would simply be exponentially worse that what I have now.
I'm reasonably confident this is a single load. Just so unbelievably slow.
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |