How to Reuse Credentials Across Multiple Reports in Power BI Report Server
Hi everyone, I am trying to understand if it is possible to reuse the same credentials across multiple reports in Power BI Report Server. My goal is to: Set up credentials once for a data source and use them across different reports. Avoid having to configure separate credentials for each individual report. Is there any official documentation or a link that explains whether this is possible or not? I need to provide my client with documentation about this feature. Thank you in advance for your help!
Report Server connect to Azure Analysis Services How to configure Data Source?
Our RS version is September 2022. We've built a report that connects live to our AAS instance and built some additional measures in the report. Works great in PBI-RS desktop. What is the correct way to configure the Data Source in the Manage/Data sources screen? The AAS cube has a Users role with an Azure Active Directory group in that role. Under the credentials, the only options are Windows Authentication and Basic Authentication. When I set the credentials to Windows and select the radio button for "As the user viewing the report" I get the error message "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly." When I change it to "Using the following credentials", enter a Non-MFA account and password that is a member of the user group, and check the box that says "Log in using these credentials, but then try to impersonate the user viewing the report", I get the same error. When I uncheck the "Log in using these credentials but then..", same error. When I test the connection, I get "Unable to obtain authentication token using the credentials provided" When I change the authentication type to Basic Authentication and provide a username and password, test the connection, I also get "Unable to obtain authentication token using the credentials provided". I've verified that I can access the AAS instance from the on-prem report server using my own credentials and MFA. It shouldn't be that hard to connect up to AAS in a power BI model from report server. Has anyone been able to do this succesfully? Thanks in Advance!
Unable to proceed from data source credential when editing the credential.
Hi everyone, I want to setup a schedule refresh in PowerBI service. The data source of my report is coming from MySQL. When I try to edit the credential under data source, a pop out window as shown in the screenshot above shown to me, asking me to fill in Username and Password. Once I filled in all the detail (the username and password is correct), I click "sign in". The problem is the time taken for signing in seems like never ending. I've been waiting for more than 1hour already but it is still the same. May I know what is the potential reason for this? Any help or advice will be greatly appreciated!
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.
