Forum Discussion

andreas_franz's avatar
andreas_franz
Regular Visitor
8 years ago

OData refresh called multiple times

Hi,   I have a Power BI Destop application that accesses 1 Data Source which is an OData feed (from SAP). The OData feed is quite big (~650 MB) and when calling it from a web browser or SAP it take...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

andreas_franz,

How many queries does your PBIX file contain and have you applied several transformations(Merge query, append query, etc) in Query Editor?

Power BI load previews of the data returned by a query for display in the Query Editor, when your PBIX file contains multiple queries and multiple transformations, clicking Refresh in Power BI Desktop triggers a refresh of these previews, which would result in multiple call times and a long refresh time. Please disable the following option in your PBIX file, and tune the performance using Table.Buffer function.


Regards,
Lydia

andreas_franz's avatar
andreas_franz
Regular Visitor
8 years ago

Anonymous

 

Thanks for the reply!

 

I just have 1 query with a source step - nothing else. It looks roughly like this (The timeout I had to increase due to the fact that it did not finish in time):

 

let
    Source = OData.Feed("http://myserver:8001/sap/opu/odata/My_Service/My_Data_Object,null, [Timeout=#duration(0, 0, 59, 0)])
in
    Source

 

 

I have de-activated the "Background Data" but it still calls the OData feed several times, still taking the long time to finish. I have not used the Table.Buffer as I am quite new to the topic and could not get it to work.

 

Your help is highly appreciated!

Thanks and best regards,

Andreas

    • andreas_franz's avatar
      andreas_franz
      Regular Visitor
      8 years ago

      Anonymous

       

      The query I provided is the only query and it is the complete logic. There are no calculations and no other queries are referenced.

       

      I had seen the blog in a web search also but it seems to me that Table.Buffer is only applicable when having more than 1 query which is not the case for me.

       

      Regards,

      Andreas

      • acmpbi's avatar
        acmpbi
        Frequent Visitor
        7 years ago

        Hi Andreas,

         

        Were you able to find a resolution for multiple reads of OData Feed to SAP. I am facing the exact same problem.

        I have a OData Feed which roughly takes 3 minutes to fetch data in Browser but the same is taking 15 minutes when called from Power BI. 

         

        Any help is greatly appreciated.

        Thanks,

        Chandra.