topic Re: Credentials-Log into the data source as SQL Server in Report Server

Credentials-Log into the data source as SQL Server

BIBIBI — Wed, 06 Apr 2022 10:54:16 GMT

I am a new power bi user. If someone can solve my issue, I would appricate your support.

My issue is that I can not connect to data sources when I enter my ID and password in both window and basic authorization in Power BI Report Server to use sheduled refresh function. Error message is "The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. Log on failed. Ensure the user name and password are correct."

My goal is use Scheduled Refresh fucntion anyway. Below are my current condition. Please let me know if you need other information.

-Use SQL Server. I use window authorization when I login SQL Server. I think my ID and password in Power BI Server should be the same as my ID and password to login my Desktop because of using window authorization in SQL Server. I do not create any ID and password for only Power BI.

-Use Power BI Report Server.

-Create a report via Power BI Desktop and publish it in Power BI Report Server. I can connect to SQL Server in the Power BI Desktop. I do not need my ID and password to connect SQL Server in the case because I use window authorization when I login SQL Server. It automatically makes me login.

-I do not have roles of system admistrator and system use, but I have a role of content manager.

-Type and Connection string under Connection aleady populated and can not be editted because the report is published in Power BI Report Server.

-The message of Scheduled Data Refresh is "Stored credentials for this report are missing. Please go to the Data Sources page for this report and set your credentials for each data source to enable scheduled data refresh." So, import-mode is used instead of direct query.

Re: Credentials-Log into the data source as SQL Server

d_gosbell — Wed, 06 Apr 2022 11:47:24 GMT

BIBIBI wrote:

My issue is that I can not connect to data sources when I enter my ID and password in both window and basic authorization in Power BI Report Server to use sheduled refresh function.

So if you are using your windows credentials you will need to use the Windows option in the Authentication Type. What format are you using to enter your username? I normally use "domain\username" so that it is unambiguous. Depending on how your Report Server is configured if you just enter "username" then it can be interpreted as a local user on the server rather than a domain user and you will get this error about the user or password being incorrect.

Re: Credentials-Log into the data source as SQL Server

BIBIBI — Wed, 06 Apr 2022 12:09:13 GMT

Hi d_gosbell, thank you for your response. "domain\username" is used in Report Server, so I entered "domain\username" in my user name. However, it does not work.