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 SinyanNew Scheduled Refresh Plan (An error has occurred. Something went wrong. Please try again later.)
Hi there, I'm trying to add new New Scheduled Refresh Plan but I got this error An error has occurred. Something went wrong. Please try again later. Even I enabled the SQL server agent please anyone can share with me a solution.Visibility of entries on PowerBI Report Builder
Hi All, I have recently downloaded report builder and have connected it to my PowerBI Data. I need to generate a report for each company ID, as shown below: I did this by changing the visibility to the expression =IIf(Fields!CODE.Value = "COMPANY3", false, true) This part is fine because I just want to hide the code but show the data for the rest of the companies. My question is: Is there an easy way to generate this table for company 1 without having to manually change this expression every time? If I want the same report for company 1, is it possible to have a selection tool where I select company 1 and then get the same table but only where company 1's name shows. Thank you for your help
HELP! Microsoft Mashups are eating my memory
Ever since I updated to the new Report Server, my PBI server is getting killed by Mashups. It looks like they are not being released after use and just keep building up until I start to loose functionality. Paginated reports start getting 403 errors. Eventually I stop and restart the Report server and that buys me another few hours. 8 processor and 24G memory. Used to be 12G and that was just fine.
Generate scheduled Power BI reports to FTP or SharePoint
Greetings, I see where you can use Subscribe to schedule reports to be emailed to users. Is there a way to schedule reports to be generated daily, monthly etc and then be sent to a file server or SharePoint location from Power BI so that they are stored there? Thanks
Report renders very slow
Hello, The PBI report takes >30sec to render, this is too slow (using Edge, Chrome is the same slow). Posting the problem in this section as we have on-prem Report Server. After 4-6 sessions with Microsoft, with them obtaining various run logs from us, we are informed unless we have a break to fix problem, Microsoft support cannot help us 😞 The PBI report has the following visuals and Data Connect Mode is Import (about 200 data rows - few seconds to refresh daily ). 1) 1 Bing Map of North America 2) 1 Area chart 3) 4 Slicers and 1 Text Filter 4) 9 Images 5) 18 Advanced Cards (We have the latest May2021 Report Server) The Model in the report is a star-schema. Performance analyzer showed the max DAX query is only 43ms, Visual display and Other are high ones. Current PBI Server is a 4core CPU and max CPU peaked at 58% only (PBI Server, DB and Web all in the same VM). Microsoft said adding CPU would not make a difference. I am trying to trace with the DevTool (F12) in Edge, the 'reportServerHost.js' took 15sec and many processes have long stalled/waiting states. Don't understand what it all means, thinking maybe this can help explain the slow report render. I am hoping the PBI community can help explain or have suggestions on how the report could be improved for render performance. Thank you. Btw, I did another test with a report that just displays 'Hello' (no DB). It took 8sec to load in the browser.
