blocks|key|172858|text|选择所有PowerPivot表|type|unordered-list-item|depth|inlineStyleRanges|entityRanges|data|172859|复制数据|172860|通过文本文件中的数据(例如，PPtoR.txt)|172861|使用制表符分隔符读取R中的文本文件:+read.table("PPtoR.txt"，sep=“\t”.)|172862|unstyled|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|M|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|N|8|@]|9|@]|A|$]]|$1|H|3|-4|5|I|7|O|8|@]|9|@]|A|$]]]|J|$]]

<ul>
<li>Select all the PowerPivot table</li>
<li>Copy the data</li>
<li>Past the data in a text file (for example PPtoR.txt)</li>
<li>Read the text file in R using tab delimiter: read.table("PPtoR.txt", sep="\t"...)</li>
</ul>

blocks|key|543534|text|要将PowerPivot表导入Excel：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|543535|根据您的PowerPivot数据创建一个枢轴表。|ordered-list-item|543536|确保您创建的pivot表在值区域有一些内容，但在过滤器、列或行区域中没有。|543537|转到Data+>+Connections。|543538|选择数据模型并单击“属性”。|543539|在“使用”选项卡中，OLAP按需要设置要检索的最大记录数(最大为9999999条记录)。|543540|双击枢轴表中的度量值区域以钻通。|543541|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|S|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|T|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|U|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|V|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|W|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|P|$]]

To get a PowerPivot table into Excel:

<ol>
<li>Create a pivot table based on your PowerPivot data. </li>
<li>Make sure that the pivot table you created has something in values area, but nothing in filters-, columns- or rows areas.</li>
<li>Go to Data > Connections.</li>
<li>Select your Data model and click Properties.</li>
<li>In Usage tab, OLAP Drill Through set the Maximum number of records to retrieve as high as you need (maximum is 9999999 records). </li>
<li>Double-click the measures area in pivot table to drill-through. </li>
</ol>

blocks|key|172916|text|另一个解决办法是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|172917|将Power透视模型导入到PowerBi桌面|unordered-list-item|172918|使用Powershell脚本导出PowerBI桌面的结果|172919|下面是一个例子|172920|CSV|offset|length|172921|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/djouallah/PowerBI_Desktop_Export_CSV^0|0|0|0|0|0|3|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|W|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|X|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Y|8|@]|9|@$K|Z|L|10|1|11]]|A|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

another solution is

<ul>
<li>import the Powerpivot model to PowerBi desktop</li>
<li>export the results from PowerBI desktop using a Powershell script</li>
</ul>

here is an example

<a href="https://github.com/djouallah/PowerBI_Desktop_Export_CSV" rel="nofollow noreferrer">https://github.com/djouallah/PowerBI_Desktop_Export_CSV</a>

blocks|key|172937|text|下面是一个纯Excel+/+VBA解决方案。这是从代码这里中修改的，可以使用FileSystemObject并一次向文件写入1k行。您需要添加Microsoft+ActiveX数据对象库和Microsoft脚本运行时作为引用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|172938|Option+Explicit

Public+FSO+As+New+FileSystemObject

Public+Sub+ExportToCsv()

++++Dim+wbTarget+As+Workbook
++++Dim+ws+As+Worksheet
++++Dim+rs+As+Object
++++Dim+sQuery+As+String

++++'Suppress+alerts+and+screen+updates
++++With+Application
++++++++.ScreenUpdating+=+False
++++++++.DisplayAlerts+=+False
++++End+With

++++'Bind+to+active+workbook
++++Set+wbTarget+=+ActiveWorkbook

++++Err.Clear

++++On+Error+GoTo+ErrHandler

++++'Make+sure+the+model+is+loaded
++++wbTarget.Model.Initialize

++++'Send+query+to+the+model
++++sQuery+=+"EVALUATE+<Query>"
++++Set+rs+=+CreateObject("ADODB.Recordset")
++++rs.Open+sQuery,+wbTarget.Model.DataModelConnection.ModelConnection.ADOConnection
++++Dim+CSVData+As+String
++++Call+WriteRecordsetToCSV(rs,+"<ExportPath>",+True)

++++rs.Close
++++Set+rs+=+Nothing

ExitPoint:
++++With+Application
++++++++.ScreenUpdating+=+True
++++++++.DisplayAlerts+=+True
++++End+With
++++Set+rs+=+Nothing
++++Exit+Sub

ErrHandler:
++++MsgBox+"An+error+occured+-+"+&+Err.Description,+vbOKOnly
++++Resume+ExitPoint
End+Sub



Public+Sub+WriteRecordsetToCSV(rsData+As+ADODB.Recordset,+_
++++++++FileName+As+String,+_
++++++++Optional+ShowColumnNames+As+Boolean+=+True,+_
++++++++Optional+NULLStr+As+String+=+"")
++++'Function+returns+a+string+to+be+saved+as+.CSV+file
++++'Option:+save+column+titles

++++Dim+TxtStr+As+TextStream
++++Dim+K+As+Long,+CSVData+As+String

++++'Open+file
++++Set+TxtStr+=+FSO.CreateTextFile(FileName,+True,+True)

++++If+ShowColumnNames+Then
++++++++For+K+=+0+To+rsData.Fields.Count+-+1
++++++++++++CSVData+=+CSVData+&+","""+&+rsData.Fields(K).Name+&+""""
++++++++Next+K

++++++++CSVData+=+Mid(CSVData,+2)+&+vbNewLine
++++++++TxtStr.Write+CSVData
++++End+If

++++Do+While+rsData.EOF+=+False
++++++++CSVData+=+""""+&+rsData.GetString(adClipString,+1000,+""",""",+""""+&+vbNewLine+&+"""",+NULLStr)
++++++++CSVData+=+Left(CSVData,+Len(CSVData)+-+Iif(rsData.EOF,+3,+2))
++++++++TxtStr.Write+CSVData
++++Loop

++++TxtStr.Close

End+Sub|code-block|syntax|javascript|172939|entityMap|0|LINK|mutability|MUTABLE|url|https://www.kasperonbi.com/export-a-table-or-dax-query-from-power-pivot-to-csv-using-vba/^0|R|2|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

A pure Excel / VBA solution is below. This is adapted from the code <a href="https://www.kasperonbi.com/export-a-table-or-dax-query-from-power-pivot-to-csv-using-vba/" rel="nofollow noreferrer">here</a> to use FileSystemObject and write 1k rows at a time to the file. You'll need to add Microsoft ActiveX Data Objects Library and Microsoft Scripting Runtime as references.

<pre><code>Option Explicit

Public FSO As New FileSystemObject

Public Sub ExportToCsv()

 Dim wbTarget As Workbook
 Dim ws As Worksheet
 Dim rs As Object
 Dim sQuery As String

 'Suppress alerts and screen updates
 With Application
 .ScreenUpdating = False
 .DisplayAlerts = False
 End With

 'Bind to active workbook
 Set wbTarget = ActiveWorkbook

 Err.Clear

 On Error GoTo ErrHandler

 'Make sure the model is loaded
 wbTarget.Model.Initialize

 'Send query to the model
 sQuery = "EVALUATE &lt;Query&gt;"
 Set rs = CreateObject("ADODB.Recordset")
 rs.Open sQuery, wbTarget.Model.DataModelConnection.ModelConnection.ADOConnection
 Dim CSVData As String
 Call WriteRecordsetToCSV(rs, "&lt;ExportPath&gt;", True)

 rs.Close
 Set rs = Nothing

ExitPoint:
 With Application
 .ScreenUpdating = True
 .DisplayAlerts = True
 End With
 Set rs = Nothing
 Exit Sub

ErrHandler:
 MsgBox "An error occured - " &amp; Err.Description, vbOKOnly
 Resume ExitPoint
End Sub



Public Sub WriteRecordsetToCSV(rsData As ADODB.Recordset, _
 FileName As String, _
 Optional ShowColumnNames As Boolean = True, _
 Optional NULLStr As String = "")
 'Function returns a string to be saved as .CSV file
 'Option: save column titles

 Dim TxtStr As TextStream
 Dim K As Long, CSVData As String

 'Open file
 Set TxtStr = FSO.CreateTextFile(FileName, True, True)

 If ShowColumnNames Then
 For K = 0 To rsData.Fields.Count - 1
 CSVData = CSVData &amp; ",""" &amp; rsData.Fields(K).Name &amp; """"
 Next K

 CSVData = Mid(CSVData, 2) &amp; vbNewLine
 TxtStr.Write CSVData
 End If

 Do While rsData.EOF = False
 CSVData = """" &amp; rsData.GetString(adClipString, 1000, """,""", """" &amp; vbNewLine &amp; """", NULLStr)
 CSVData = Left(CSVData, Len(CSVData) - Iif(rsData.EOF, 3, 2))
 TxtStr.Write CSVData
 Loop

 TxtStr.Close

End Sub
</code></pre>

blocks|key|1411639|text|这里有一个可爱的低科技方式：https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1411640|我认为在Excel+2016中，这个过程有点不同。如果您有Excel+2016，只需转到Data选项卡，获取外部数据，然后是现有的连接(然后在表下面查看)。|1411641|另一件重要的事情是点击Unlink+(表工具下-设计-外部表数据)。这将从源数据中解锁，因此它实际上只是一个导出。|1411642|如果愿意，可以将该数据复制到另一个工作簿中。|1411643|entityMap|0|LINK|mutability|MUTABLE|url|https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/^0|E|24|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

Here is a lovely low-tech way:
<a href="https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/" rel="nofollow noreferrer">https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/</a>

I think the process is a little different in Excel 2016. If you have Excel 2016, you just go to the data tab, go to Get External Data, and then Existing Connections (and look under Tables).

The other important thing is to click on Unlink (under Table Tools - Design - External Table Data). This unlinks it from the source data, so it really is just an export.

You can copy that data into another workbook should you wish to.

blocks|key|1411660|text|Power中的数据是建模的，使用DAX将数据导出到csv或SQL。完成后，您将看到每个模型对应于一个CSV文件或SQL表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1411661|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Data in Power Pivot is modeled, using DAX Studio to export data to csv or SQL.
after finished, you will see that Each model corresponds to a CSV file or SQL table.

I have an enormous PowerPivot table (839,726 rows), and it is simply too big to copy-paste into a regular spread sheet. I have tried copying it and then reading it directly into R using the line <code>data = read.table("clipboard", header = T)</code>, but neither of these approaches work. I am wondering if there is some add-on or method I can use to export my PowerPivot table as a CSV or .xlsx? Thanks very much

Exporting data from PowerPivot

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我有一个巨大的PowerPivot表(839,726行)，它太大了，无法复制粘贴到常规的扩展表中。我尝试过复制它，然后使用行data = read.table("clipboard", header = T)直接将其读取到R中，但这两种方法都不起作用。我想知道是否有一些附加或方法可以用来将我的PowerPivot表导出为CSV或.xlsx？非常感谢

问从PowerPivot导出数据
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从PowerPivot导出数据EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从PowerPivot导出数据
EN