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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors