Cant connect the datasource SQL Server Database in the report server
Hello Community, I created a report in the power bi desktop version and now wanted to upload the report on the report server which all worked out(once i had saved the file as a report server). I however can't seem to connect to the SQL server database as my one and only data source and can therefore not set up an automatic refresh of the report. Just some back info the report is based on an Import mods and I first created the report on the desktop version before saving the document as power bi desktop report sever document. I think the problem might be with the fact that I didn't originally create the report in the report server version of desktop and/or that there is something wrong with my connecting string(was automatically filled in and I cant edit it). On the desktop version I can refresh the data without any problem as I am connected to the SQL database but it simply doesn't work with the report server.I've attached pictures showing my error sign to give more context. I also tried the two authentication methods possible (standard authentication and Microsoft authentication and both didn't work) I would be very grateful for any assistance the community could give me,as I need to present this tomorrow to my bosses and cant find a solution. Kind regards, Philip Sinyan
SSRS Report does not show in chrome for all user
Hi we have used power BI and SSRS for our organization since two years ago. suddenly, from two days ago, the whole SSRS reports have stayed at loading stage on some clients and do not show on chrome and edge browsers. we tried a lot of proposed solution such as upgrading report server to 2022 version and restarting different sql services. can any body help me to solve this issue?how to automate changing password for gMSA user account for Report Server SQL DataSource
Dear PBI experts, Pls provide advice I faced following situation: for my PBIX file SQL Database used as DataSource i need to organize process of refresh data model by means of using gMSA windows domain account. When i put gMSA account into User name Report Server asks me for gMSA password, but as username is gMSA, i expect password for gMSA to be provided automatically. should i use some Power Shell script for this task to change gMSA password automatically? or there are some alternatives ways you may recommend to change password automatically without need of manual password changing ? Bst rgrds, Alexsandr
Report not showing visuals with error message on Report Server
Hi, we've deployed a report on the Report server which uses mainly SQL queries to get all the data. When opening the file locally it opens fine with no errors. But once on the Report Server most of the visuals don't load and each say that a relationship can't be found (as per images below). Any help will be greatly appreciated. The connection to the data source is correct as other reports use the same one and are running fine.
