Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |