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
MultiColumn Paginated Report Grouping/Sorting
Hi! I looking to make a paginated report to show a free form box with a variety of data in it, and then to have multiple columns across the page. I have seen you can do a multicolumn report, where you set the report to have 4 columns. Except with the multicolumn report, I can't see how to sort across the page and then down. It sorts my items down the page then across. The other method I saw was to create identical tablixes across the page and in each of them have a row visibility formula = =IIF((RowNumber(Nothing) Mod 4) = 1, False, True) ect. and that seems to work with sorting across then down. The next challenge comes when I want to do page breaks and sorting. I want the report to group by Category and then Gender and within each group sort by Sales $ across the page then down. I also want the category and gender to show on the top of each page for the page break. The only way I could figure out how to get a title to change with each page break was to wrap my tablixes in a list (the red box). I was able to get the titles to change each time there is a page break except it doesn't stay if there are 2 pages in the same grouping. Then my sort wasn't working. My second grouping started sorting with the 4th column being the highest value, not sure why that is happening. What is the best route to do this? if I have to use the 4 tablixes wrapped in a list, what part do I put the sort and grouping on, the list or the tablix's? The group properties or tablix properties? Any help would be appreciated.
Power BI Report Server - SQL Server Data Source Connection
Hello d_gosbell , I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source. IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI. Once I input the required details here (Server, database, also added a SQL Statement in advanced options). Next, I input the required database user and password. The IT dept has connected the ports to ensure connection is established to the SQL Server. However, after that this error comes up. Kindly assist on how to fix this error. Thanks in advance! Appreciate the support.Pie chart is not displaying in print layout correctly
I am building my first report in report builder built off a power bi dataset. It is a very basic report. Everything is displaying correctly except the pie chart. The first thing I notice is the font size of the chart title "Extended Cost" is set to 8 but it is appearing larger than my report title that is set to 18. It appears correctly when I am not in print layout. Any ideas? Print layout Regular design modeData Gateway Cluster is not showing
hello all, My colleague created an on-premise gateway on the server it self and gave me the name of the gateway. The problem is that this should appear automatically on the list of data gateways in power bi right? if yes, its not showing for me and I tried each and every way to show it but its not working. if no, then how can I show this on- premise gateway on my power bi gateway clusters?Report table design with data points in both columns and rows (need help)
Good afternoon, all! I am absolutely new to the world of Power BI paginated report design, and am in need of some assistance with a table design that includes data points in both columns and rows.... I have an existing report design in our current reporting environment (see pic), that contains data in both colomns and rows. This design works just fine, and the 3 rows (Description, Immediate, Lessons) each show up between each Record item (see pic). My question is, how would I create something similar as a paginated report? I have the below design: But, when I run the report in the PBI Report Designer, I get the following output: Any help would be greatly appreciated. Thanks, Scott
