Power BI ::从网页导入数据时，我是否需要网关连接？
我有困境。
我正在从此页面上获取数据锂公司在澳大利亚市场上列出。因此，这意味着数据源是... Web！
我将仪表板保存在我的电源BI帐户上，并且由于源是网络，所以我希望Power BI每隔几个小时自动刷新数据。
但是显然这是不起作用的。
我的Power BI帐户要求我安装网关连接，通常为本地数据来源做的Thig：
您没有任何数据网关。我们找不到任何合适的数据 网关连接到该数据集使用的数据源。任何一个 安装本地数据网关，并添加数据源 数据集用于它，或以个人模式安装数据网关 将此数据集连接到其数据源
这是如此愚蠢。
数据来自Web，没有任何必要安装任何网关连接。
我已经看到其他人遇到了同样的问题：
- 网关？
- workaround：如何使用网页的计划刷新而无需网关（不，这是如此丑陋，我很难m不走兔子洞...）
请告诉我，我绝对错了，从中有一个简单的方法。
谢谢
编辑： @ffffrank试图帮助我，但解决方案不起作用。
另外，我相信根本原因是其他原因：
Last refresh failed: Fri Apr 22 2022 10:41:47 GMT+0200 (Central European Summer Time)
Scheduled refresh has been disabled.Hide details
Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
I have a dilemma.
I'm picking up data from this page where I can have a clear view of all lithium companies listed on the Australian market. So this means that the data source is... web!
I save and publish the dashboard on my Power BI account and because the source is Web I would like Power BI to automatically refresh the data every few hours.
But apparently it doesn't work like that.
My Power BI account is asking me to install a Gateway connection, thig that you usually do for an on-prem data source:
You don't have any data gateways. We didn't find any suitable data
gateways to connect to the data sources that this dataset uses. Either
install an on-premises data gateway and add the data sources that this
dataset uses to it, or install a data gateway in personal mode to
connect this dataset to its data sources
This is so idiotic.
The data are coming from the web, there is no point to install any gateway connection whatsoever.
I've seen that other folks are having the same problem:
- Gateway needed for web data ?
- WORKAROUND: How to use scheduled refresh of a web page without the need for a gateway (Nah, this is so ugly, I'm not going down the rabbit hole... )
Please, tell me I'm absolutely wrong and there is an easy way out of this.
Thank you
EDIT:
@ffffrank tried to help me out but the solution isn't working.
Plus I believe the root cause is something else:
Last refresh failed: Fri Apr 22 2022 10:41:47 GMT+0200 (Central European Summer Time)
Scheduled refresh has been disabled.Hide details
Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
转到电源查询和高级编辑器。您的第一行希望看起来像这样：
将其切换到：
现在它应该在没有门户的情况下工作。
Go to Power Query and Advanced editor. Your first line hopefully looks something like this:
Switch it to:
Now it should work without a gateway.
我认为我找到了一个解决方案，或者至少是一个解释，因为为什么Power BI报告的语义模型臭名昭著地试图访问报告开发人员本地机器上的数据网关，以从公共网络服务中获取数据。
答案是 OneDrive ！
尝试以下内容：
I think I found a solution, or at least an explanation, for why a semantic model of the Power BI report notoriously tries to access a data gateway on the report developer's local machine to get data from the public web service.
The answer is OneDrive!
Try the following: