cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BSkeelsParadise
New Member

Error exporting data

Using the Power BI Power Query designer, when attempting to export the data, an error is appearing.

"Your mashup exceeded the maximum length allowed by this service and cannot be saved. The 

last operation did not succceed, please refresh this mashup to continue.

 

Details

Request ID: 

Session ID:

Mashup length: "2707.94KB"

Maximum length: "512.00KB"

"

Is there a way around this maximum length value? 

3 REPLIES 3
BSkeelsParadise
New Member

Hi, thank you for your reply and sorry for the confusion. I was posting this on someone's behalf and they have clarified what exactly they were doing. 

They were copying data from a large table in Excel and pasting this in to Power BI, to then manipulate the data in Power BI. The error appeared when attempting to paste the data in.

Hi @BSkeelsParadise 

 

Thank you for your feedback. Can you help confirm were they copying data from a table in Excel then pasting the data into Power BI Desktop through Enter Data? It might be because the table structure wasn't detected correctly in the Create Table window and multiple values were pasted into the same cell leading to exceeding the length limit.

062306.jpg

 

You could click any cell in range of the table in Excel, use Ctrl + T to create a table. Then copy this table into Power Query Editor. In this way, it can be detected and pasted more correctly. 

062307.jpg

 

However, since they were getting data from a large table in Excel, I would suggest using the Excel connector directly. This is designed to get data from Excel Workbooks and is easy to use. This will load data from Excel into Power BI report. The manipulations in Power BI will not influence the data in your Excel files. Connect to Excel in Power BI Desktop - Power BI | Microsoft Docs

062308.jpg

 

Hope this helps.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang
Community Support
Community Support

Hi @BSkeelsParadise 

 

Can you share how did you export the data from Power Query Editor? 

 

In addition, if you want to export data from Power BI Desktop, you could try R/Python methods or use DAX Studio.

Export data from Power Query to Local Machine or SQL Server using R scripts - RADACAD

Exporting Data From Power BI to SQL Server Using Python | Sandeep Pawar

DAX Tools - DAX Studio 15 – Export data - YouTube

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors