Questions tagged [power-bi-report-server]

Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs.

385 questions
7
votes
1 answer

Edit URL Link to Report Server within SSRS Subscription

I recently upgraded from SSRS Report Server 2008 to Power BI Report Server 2017. I have set up an alias URL link to get to the server as well. When sending a report from the new server via an email Subscription, there is an option to send a link to…
Caleb
  • 75
  • 1
  • 7
4
votes
0 answers

PowerBI on-premises: Authentication Token without AAD access?

I have an environment that is entirely on-premises( PowerBI Report Server ). I will show my reports to the external users logged in my company site through Iframe. Problem: External users will see the report on the company page. I need to secure…
4
votes
1 answer

Status: Unauthorized (401) error while getting the reports from the workspace

I have created my app and registered over https://dev.powerbi.com/Apps as Native. In Azure, I added myself ad global admin user, registered myself to the application as admin, granted all Power BI API permissions. I created a workspace, added myself…
4
votes
1 answer

How to render report charts after filters are applied in PoweBI

Normally in BI tools, I open a report page, see empty tables, their column names, and empty charts. I select some filters from header place and click on the View button to query report and see the result. But in PowerBI, when I open a published…
3
votes
3 answers

PowerBi Report Server (PBIRS Jan 2021) Says "couldn't connect to the Analysis Services server" even though im not using it

We have 3 servers Dev, Test & Live. Each Server is: Win2012R2 SQL2016 SP2-CU15-GDR 13.0.5865.1 and PBIRS: Version 1.10.7737.32652 (January 2021) We have one report, which works on Dev and Test, but fails in Live with the following error: An…
Sir Swears-a-lot
  • 402
  • 7
  • 20
3
votes
0 answers

Power BI: Do not output empty leaves in the hierarchy, Power BI / VS Report Builder, Joining two or more tables

Project Project PowerBI I ask for your help, have already climbed a bunch of resources and can not find a suitable solution The problem is this: There is a heterogeneous hierarchy in the visual element (matrix), how to remove the empty leaves…
3
votes
1 answer

Can not upload Report to Power BI Report Server

I've the Power BI Desktop RS Version as 1.5.7074.36177 (May 2019) and Power BI Report Server (Development version): 2.73.5586.1501 64-bit (September, 2019) I tried to save the report to PBI RS, it is throwing following error: We can't save this…
3
votes
1 answer

Paginated report- export to pdf for all individual filter values separately

Is there really a way to export Power BI reports for each filter value separately in a PDF/PowerPoint file? Some users have asked this question before on Power BI community forums (this and this) and the accepted solution is to use a Paginated…
3
votes
2 answers

How to set slicer value to first available value form table in Power BI?

I have a requirement that the selected value in slicer must be valid. Let us suppose if I select a value in Store slicer and that store gets deleted from the company. The slicer will still show its name with no data in visuals interacting with the…
3
votes
1 answer

Is there a way to run an R script in Power BI Server when using an Enterprise Gateway?

I have included an R Script in a PowerQuery in Power BI to transform data. This works in Power BI Desktop, however when I push to Power BI Server I receive the following error message when looking at the (Enterprise)…
Brisbane Pom
  • 521
  • 7
  • 18
3
votes
1 answer

Embed non-group workspace report using Power BI Rest API

I want to embed Power BI non-group workspace report in my application i.e., the reports that I have created or are shared with me and are not published to any workspace. I gone through the articles for embedding the report but didn't find any…
3
votes
0 answers

Is the Power BI Javascript API supported in Power BI Report Server?

I would like to know if the Power BI Javascript API is supported in Power BI Report Server. If Yes, then how?
3
votes
2 answers

Custom title AND logo in PowerBI Report Server

I have a Power BI Report Server 2017 to which I have applied a branding package, as per this guidance. However I cannot find a way to have both a title and a logo at the top of the page. Including in metadata.xml…
aucuparia
  • 2,021
  • 20
  • 27
3
votes
1 answer

How to publish a (.pbix) report from Power BI Desktop directly to a Power BI Report Server (on-premises)

I've created a report in the "Power BI Desktop optimized for Power BI Report Server (October 2017)" app and want to deploy it directly to local Power BI Report Server instance but can't find a way to do that. I found a page on Microsoft Docs called…
Andrey Morozov
  • 7,839
  • 5
  • 53
  • 75
2
votes
1 answer

ReportServerPowerBI - dbo.ExecutionLogStorage - columns meaning

I want to build some basic monitoring/dashboard for reports (paginated/PBI). I am reading table dbo.ExecutionLogStorage, but I don´t know some values in the columns. Column ReportAction --> I know this below --> CASE(ReportAction) WHEN 1 THEN…
1
2 3
25 26