Forum Discussion

mafl089's avatar
mafl089
Regular Visitor
6 years ago
Solved

Dataflow refresh failing without details

Hi there, I created a dataflow for OData URLs (of our Dynamics NAV 2013 R2 installation), connected to our Data Gateway. First everything worked well, now the dataflow starts failing on refresh. I...
dataflow
Need Help
  • mafl089's avatar
    mafl089
    6 years ago

    I think I found the problem by my own.

    I found some blog post (couldn't find the URL anymore) which pointed me into the direction of the default page size settings of Navision OData service. This is set to 1000 in Dynamics NAV 2013. And Power BI simply can't handle this pagination...(holy c***)...

    So:

    1. increased pages setting in NAV service on server + restarted service (Dynamics, not data gateway!)
    2. refresh query (Power BI Desktop test) + refresh dataflow => works

     

    Something more like a bug than wanted behaviour, isn't it?

mafl089's avatar
mafl089
Regular Visitor
6 years ago

I think I found the problem by my own.

I found some blog post (couldn't find the URL anymore) which pointed me into the direction of the default page size settings of Navision OData service. This is set to 1000 in Dynamics NAV 2013. And Power BI simply can't handle this pagination...(holy c***)...

So:

  1. increased pages setting in NAV service on server + restarted service (Dynamics, not data gateway!)
  2. refresh query (Power BI Desktop test) + refresh dataflow => works

 

Something more like a bug than wanted behaviour, isn't it?

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi mafl089 ,

     

    Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, we have learned a lot from it. if you have any other questions about this scenario, please kindly ask here and we will try to resolve it.


    Best regards,