Power BI：使用Excel文件和数据库作为数据源时本地网关问题
这可能是我忽略的简单的事情，但这是我正在发生的事情：
我已经构建了一个仪表板，该仪表板从数据库中源下来。该报告还使用了其他几个表格，使用了Excel文件（存储在我的本地计算机和我们的OnePoint驱动器上）。 我们已经设置了本地网关，以便已发布的报告可以从数据库中访问表。通过管理网关页面，它显示在线显示： 网关 - 在线状态
打开报告仍然显示错误，并说没有网关连接。请参阅此处： no Gateway Connection
当我进入数据集设置时，似乎是Excel File是引起问题的原因： Gateway设置问题
有人知道我需要做什么来修复解决方案这？如何与OneDrive上的Excel文件建立连接并将其从已设置的网关群集分离？
this is probably something simple that I am overlooking, but here's what I have going on:
I've built a dashboard that sources a few tables from my database. The report is also using an Excel file (which is stored on my local machine and our OnePoint Drive) for a couple other tables.
We've set up the on-premise gateway so that the published reports can access the tables from the database. Through the Manage Gateways page, it shows online:
Gateway - Online Status
Opening the report still shows errors and says there is no gateway connection. See here: No gateway connection
When I go to the dataset settings, it seems that the Excel file is what is causing the issue: Gateway setting issues
Does anyone know what I need to do to fix this? How do I make a connection to the Excel file that is on OneDrive and detach it from the gateway cluster that has been set up?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看起来您正在使用本地文件路径。如果它在OneDrive中，请打开查询，然后更改源以直接指向云版本。这里有说明： https：/ /en-us/power-Query/sharepoint-oneDrive-files
Looks like you're using a local file path. If it is in OneDrive, open the query and change the source to point directly at the cloud version. There are instructions here: https://learn.microsoft.com/en-us/power-query/sharepoint-onedrive-files