cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BIBIBI
New Member

Credentials-Log into the data source as SQL Server

Hi 

 

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.

2 REPLIES 2
d_gosbell
Super User
Super User


@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.

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.