How can I improve the performance of PowerBI <> MS Project Online?

[Netrelemo]

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.

• Connect to data source and choose tables - no problem < 5sec
• Load tables - 5 seconds to load 100 rows... but if I page down and page up it has to reload all the rows.
• Select Edit Queries  - no problem < 5 sec
• Search for a field in a table, using the search - starting to get slow - 5 seconds just to produce a filtered list of fields
• Do some transformation - slow ... 5 seconds for every action
• Load results (Close and Apply) -
  • The transfer rates seem to be about 1 Mb / 10 sec
  • It takes about 30 minutes to load 38,000 rows.
• Then I need to edit the query again, and we start over.

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?

[mwegener]

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.

[v-frfei-msft]

Hi @Netrelemo ,

How about using Data flow?

[Netrelemo]

I don't think a re-engineering a whole data flow to build a model is a sustainable solution. 

[mwegener]

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.

[Netrelemo]

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.