Forum Discussion

JulianS's avatar
JulianS
Advocate II
8 years ago

Table.Buffer in Power BI Service

Hi everyone,   can anyone help me out with some information about the Table.Buffer function in the power bi service? I have quite a huge import based on web services returning CSV data when reques...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi JulianS,

 

Actually table.buffer function will cache table to memory to increase calculation performance, I don't think it will be works for refresh operation on power bi service.

 

You can also submit a ticket to contact to power bi team to confirm this scenario.

submit a support ticket

 

Regards,
Xiaoxin Sheng

  • JulianS's avatar
    JulianS
    Advocate II
    8 years ago

    Hi Anonymous,

     

    right now i would be interested in how and why this behaviour is different in service and Desktop so i can plan the import for other customers differently.

    Any help would be appreciated. 

    The only workaround i can think of right now, would be to create a automatic daily export transfer of the CSV files from the API to Sharepoint (or other folder) and import from that source.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Julian,

       

      Just wondering if this was ever resolved and if not are you able to give me a preview of how your workaround is constructed because I'm trying to do a table buffer in powerbi service as well through a dataflow but is giving me an error