Scheduled refresh fail with Microsoft Dynamics Odata feed

[Dubock]

Hi,

The PowerBI service shows the same error all the time and hope this community can help me to solve the problem. I will explain the situation below:

The PowerBI desktop refresh works fine for all my projects but the service shows some errors and i don't know why. I'm using the Odatafeed of Microsoft Dynamics Nav and sharepoint (onedrive) for my data.

I have 3 different datasets for each Business Unit in our company. Water and Care.

Business Unit MSM Water

MSMWAter_realtime_overview works fine, i don't have errors with this dashboard and dataset over the last 3/4 weeks.

I'm also using a filter for the general ledger. (Just hide the url of the server by URLHIDE)

let
Source = OData.Feed("https://URLHIDE')/Grootboekposten?$filter=Posting_Date%20ge%20datetime%272018-01-01%27"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Amount", type number}, {"Remaining_Amount", type number}})
in
#"Changed Type"

This works perfect. It has not more than 5000 rows at this moment.

Business Unit Care

At my other Business Unit Care, i have the same table but with 13.000 rows.

The setup is the same as the Water dataset but i receive only error while refreshing the dataset in the PowerBi Service.

Can anyone help me with this issue?

Thank you in advance.

Jerry

[v-jiascu-msft]

Hi Jerry,

Please mask your private data in the post. 

How about deleting the filter of the URL and filtering the data in the Query Editor? Otherwise, I would suggest you file a support ticket here.

Best Regards,

Dale