适用于 SQL Server 的 PowerBI Online 与桌面凭据 [英] PowerBI Online vs Desktop Credentials for SQL Server

问题描述

我创建了一个报表，它在 Power BI 桌面上使用 DirectQuery.在桌面应用程序上，我能够连接到我的 SQL Server 并检索查询.但是，在线发布报告后，我收到错误数据源缺少凭据，无法访问".我在桌面上拥有所有凭据并清除并重新输入凭据，但我仍然在网上遇到同样的错误.

I created a report, which uses DirectQuery on Power BI desktop. On the desktop app, I am able to connect to my SQL Server and retrieve the queries. However, after publishing the report online I get an error The data source '' is missing credentials and cannot be accessed. I have all the credentials in the desktop and cleared and reentered the credentials, but I am still getting the same error online.

推荐答案

您需要转到 Power BI 服务 Web 应用中的数据集页面，您应该会看到凭据错误，以及修复它的链接.

You need to go to the dataset page in the Power BI Service web app, and you should see credential errors, with a link to fix it.

如果它是 Azure SQL DB，那么就应该只需要这些.

If it's Azure SQL DB, that's all that should be needed.

如果服务器位于本地，您还需要配置网关并确保其正常工作.

If the server is on-premises, you'll also need to configure the gateway and make sure it works.

这篇关于适用于 SQL Server 的 PowerBI Online 与桌面凭据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！