Username and Password not working to connect Gateway
We have a PowerBI gateway to Databricks that username and password stopped working in the beginning of October. We have tried multiple users with access, and verified passwords have not expired, and we are getting: "PowerBI: [Microsoft][ThriftExtention](8) Authentication/authorization error occured. Error details: Bad status with no error message: Unauthorized/Forbinne: Status Code: 403" These same accounts are able to use access keys from Databricks to connect the gateway, but not username and password. All these accounts have full access to the Connector, PowerBI and Databricks. Some people with similar issues said to reenter credentials, this has not worked and we cannot use credentials at all... Only Access Token. Anyone input would be appreciated.Resolving of Username results in UPN
Hello Community, I have a problem with the resolution of the username function in the report server context. I have a dataset (imported data from Excel, which is then published to the RS) in which I have built an RLS. For resolution, I usually use the username() function. If I check the function via PowerBI Desktop RS on the server instance of the RS, the username() can be resolved in the format Domain\Username. If I publish the report on the RS and check the functions within the report server, e.g. in a matrix in the report, then the function Username() resolves as a userprincipalname in the format [email protected]. How can this happen? Reports based on data from SSAS cubes are available on the same report server. Username functions are also resolved in the reports. However, these are again in the expected format Domain\Username. However, the SSAS instances are located on a different server in the network. Can someone explain to me how this deviation can occur within the same RS instance? What exactly is the cause?
AD users password changing causing scheduled refresh fails
Hi, My clients use my Power BI Report Server and setup their domain account on Data sources page in order to retrieve data from shared drives. Once they change their password, the data refresh will fail to work. Do we have any means of Power BI Report Server user settings synchronisation with AD? Thank you
Power BI Report Builder - Find User Name From Power BI Cloud
Hello, Using Power BI Report Builder with reports running on Power BI Cloud with a data gateway, am trying to select the user name of the user viewing the report into a parameter. From the Built-In Fields in Power BI Report Builder have access to User ID which in Power BI Cloud defaults to the user’s email address (e.g. [email protected]). I need to exact ideally the user’s username (e.g. CORPX\johnsmi) or if not possible the user’s full name (e.g. John Smith) and/or the user’s first name (e.g. John) and last name (e.g. Smith). Is there a way to do this? The only other user Built-In Field that have seen is language. ThanksFilter by USERNAME() is not working in some visuals
Hello all! I created a simple table “All suppliers” and “My suppliers”. The “My Suppliers” option filters the data according to the USERNAME () of the user who is accessing the report. The problem is that the filter is disabled for some visuals (eg cards), therefore, is not filtering all visuals.😥 Does anyone know what the problem is? Link table with USERNAME: Table “All suppliers” “My Suppliers”: Measure: Filtering visual (when is enabled) Filtering visual (disabled) Thank you in advance!
Slicer Options depending on logged in User
Hi Everyone: I would like a Slicer that I have in one of my pages to expose (or not expose) products from the PRODUCTS Table based on the USER that is logged in from the Power BI service. So, for some USER, some subset of PRODUCTS should be exposed, and for some other USER another subset of PRODUCTS should be exposed. How do I do that? (NOTE: I think RLS won't work for me, because RLS will expose (or not expose) those same PRODCUTS from all other visualizations (other graphics, charts, etc) , that shouldn't be impacted by who is the USER. )Add users in basic authentication
Hello, I installed my evaluate version of Power BI Report Server on a virtual machine, then I log in with admin account and upload reports where I have roles. I need to provide access to users outside my domain, so I want to use basic authentication (it's the best way, isn't it?) defining usernames and passwords. I changed the RSReportServer.config file as explained at https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-2017#main but now I don't know how to create new credentials and the only way I am able to connect is with my admin account. I read many things about security and roles assignment but I have no user to associate to one of my roles. Please help me. Thank you so muchFiltering based on username()
Hi, Currently I have some challenges with filtering based on username(). I have two tables: Employees and Userinformation. The Userinformation table contains different usernames and Employees contains different profiles. What I need: If the username is present at the Userinformation table, then I want to show all profiles from the Employees table. If not, then show no results. I am fairly new to DAX, so it might be a simple problem. Thanks in advance.
