Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
JulianS
Helper I
Helper I

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 requested.

Those imports are often referenced again by other imports and joined together to build new tables.

 

For the basic tables, i use the following import structure:

 

1. only Web.Contents(...

2.

  • Use Source from #1
  • Table.Buffer(Csv.Document...

3. 

  • Use source from #2 
  • start actual transformations on the data

I can check on my server log how many CSV requests are being made.

On the desktop the data refresh is working fine with this concept and i get 33 different requests per import as i would expect.

 

Now when this Dataset is transferred to Power BI Service and a refresh is scheduled, i can see a total amount of 232 requests were made.

Often this is too much load and requests take long, which leads to timeouts.

 

Does the service ignore Table.Buffer?

How can i adress this issue?

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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 ticketsubmit a support ticket

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft,

 

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
Not applicable

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 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.