当其中一个步骤崩溃时提取PowerQuery结果
当其中一个步骤崩溃时，是否有人可以提取电源查询结果（可以说没有办法修复它）？有很多基于电源查询的工作枢轴表，因此必须在某个地方进行数据。 Power Pivot中还有一个数据模型，我知道我可以将所有结果从Power Pivot复制并粘贴到一些工作表中，但是当我想复制这么多结果时，它会使Power Pivot崩溃
Does anyone have a way to extract power query results when one of the steps crashed (and lets say there is no way to fix it)? There are a lot of working pivot tables based on power queries so there has to be data somewhere. There is also a Data Model in power pivot and I know that I can copy all the results from power pivot and paste into some worksheet but it crashes power pivot when I want to copy so many results
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我取决于它是否像以往一样。
据我所知，
PowerQuery仅具有数据的预览。因此，它不会保留源的副本。即使我不知道您是否可以以有意义的方式访问这些预览。但是，如果在某个时候在
powerbi中加载（当您在powerQuery中点击“应用”时）。您可以使用 dax Studio 。您将在powerbi中获得更多或多或少可以看到的东西，但可以将其提取到CSV。I depends whether or not it as ever worked.
To my knowledge,
PowerQueryonly has a preview of the data. So, it does not retain a copy of the source. Even though I don't know if you can access these previews in a meaningful way.However, if it as loaded in
PowerBIat some point (when you hit "Apply" inPowerQuery). You can extract it in its current state using DAX Studio. You'll get more or less exactly what you can see inPowerBIexcept there is an option to extract to CSV.您必须进入与电源查询相对应的现有连接表和检查表
You have to go into Existing Connections and check Table that corresponds to power query and then you can load it to a sheet even if the power query is down