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
Filtering Power BI Report Server Report With URL Parameters When Table or Column Has Space
I have created a basic report to test this scenario. My report has a table called Employees and this table has a column named FirstName. I can successfully filter the report using url parameter e.g. filter=Employees/FirstName eq 'John' This works fine. The Employees table also has a column 'Last Name' and when I attempt to filter it using the same method, the report is failing to recognize the field. I am using the following syntax: filter=Employees/Last_x0020_Name eq 'Smith' I have tried this scenario on several reports and attached is how the filter appears in the report (unrecognized) . Does Power BI Report Server filtering not work with spaces in the fields?
Automatic Page Refresh not working as expected
I have a report that is using Direct-Query data mode. The option for Page refresh is available. I can select what cycle I want the page to refresh and it works while I have the report open in Desktop. After I upload it to the Report Server, it doesn't autorefresh the page. Is there something I'm missing to make this work?
