Adding a header to a web API request in the data sources section of a report in PBI Report Server
Hello everyone, I have created a report using power bi desktop (Vesrion January 2021). In order to get the data for this report, I connect to a web API using the provided API key in the header part of the request: This part works fine and I get the necessary data to work on the Power BI desktop. When I publish the created report to a Power BI Report Server, as you can see in the following image, there is no way to add the header data which in this case is mandatory to authenticate: The Authentication part in the Credential section in the above image does not support adding headers data and only accepts Anonymous, Basic, and Windows authentication which are not applicable here (The test fails). As the data in my report changes regularly and I need to schedule an automatic refresh, the Report Server has to connect to the Web API at the scheduled times in order to get the latest version of the data. I would appreciate it if you could help me to solve the encountered problem. Regards
Repeat Column Header on Each Page skips pages
Hi~ I am working on my first report -- it is probably more complex than I should be attempting, but it's 99% there. I am struggling to get my column headers to repeat on each page. I've gone through the Advanced Mode > Static > KeepWithGroup / RepeatOnNewPage settings and for the most part, it works great! However, I'm finding it will "randomly" skip a page. For example: Pages 2-10 repeats headers Page 11 has no headers Pages 12-17 repeats headers Page 18 has no headers Pages 19-21 repeats headers I can't for the life of me figure out what is going on, and I haven't had any luck searching around for a solution. 😕 Any ideas? EDIT: (5/24/2022) I ended up just deleting it and starting over and it seems to be ok now.Connecting to Reporting Server instance from SSMS
I have Power BI Reporting Server Jan 2021 installed. It is configured with Custom Security (as per this: https://github.com/microsoft/Reporting-Services/tree/master/CustomSecuritySample) PBIRS is working abosultely fine. I am able to access the portal and do all the reporting operations. However I am required to update some headers and trying to follow the steps from this link https://docs.microsoft.com/en-us/sql/reporting-services/tools/server-properties-advanced-page-reporting-services?view=sql-server-ver15. I am getting invalid user credentails, no matter what combination I try. Please help!
