Power BI Service D365 ODATA Refhresh Timeout

[Anonymous]

Hi,

I have created a data model in Power BI which is based on Entities from D365. The data is loaded via ODATA.

When pushing the report to the powerbi service the refresh runs into a timeout. But only for some entities.

Error Message:

I already tried to increase the timiemout to 30 minutes. But this did not solve the problem.

= OData.Feed("xxxxxxx?cross-company=true", null ,[Timeout=#duration(0, 0, 30, 0)])

Does somebody know a solution?

Cheers

Alex

[GilbertQ]

I would suggest trying to load the data in smaller chunks, OData can at times be very slow to get data out, and that is possibly why it is timing out.

If you could load tables in parallel and then merge them at the end?

[Anonymous]

Good Morning GilbertQ,

thanks for your replay but I had to split the data in mor chunks. I guess the main problem is the authorization per entitiy. To get data across all companys with ODATA when connecting to dynamics 365 I have to ad the parameter "?cross-company=true" to the feed. Because of that, power bi creates for every entity a conection which needs to be authorised. I guess that authorization takes to long??

Example 

Thanks.

Alex

[GilbertQ]

Hi there

That could well be the issue.

Is it possible to see if you try with one if it works successfully?

[Anonymous]

Hi,

I tried to upload just one Entity to the powerbi service which always run into a timeout.

But I get the same issue. So it has to do with the entity and not with the amount of entities.

I have still no solution and I created a ticket at microsoft.

Lets see if they can fix that issue. 

Cheers

Alex

[Anonymous · Accepted solution]

Ok the solution was to use Bring your own data instead of ODATA. The time out could not be fixed.

[Alarik]

Hi all,

we've got the same issue with timeout in PBI Service when connecting to Odata source. We found a solution using standart PBI and Odata tools. We use Odata to get data from our local accounting system, but maybe this solution could also fit D365.

What we do - we transform Odata into json and use Web connector in Power Query, not Odata:

1. Click on Get data and choose Web

2. Paste Odata url and add new parameter in the end of url   &$format=json

3. Provide credentials 

4. Convert into table

5. Click on List

6. Convert the list into table

7. Expand the columns

8. Note that all data from json is of text type, so you need to change it to appropriate.

The last thing I want to mention is that refreshing works fine only via personal gateway but  I hope that it is our local issue.