Power BI Paginated Report - Project Listed in Parameter but won't display in report
I have this report to display projects. All projects display except this one and I couldn't figure out why. Any idea how to fix this? Project# 569549 listed in Project Number parameter It doesn't render anything when selected, it doesn't give any warning either If I select a different project, it displays just fine, except 569549 Below is the query - project number is stored as text in Power BI desktop: EVALUATE SUMMARIZECOLUMNS('Active List'[Project Number], 'Active List'[Project Name], 'Active List'[Project Manager], 'Active List'[Project Description], REDACTED, 'Active List'[Phase], 'Active List'[Programs], 'Active List'[Component], RSCustomDaxFilter(@ActiveListComponent,EqualToCondition,[Active List].[Component],String), RSCustomDaxFilter(@ActiveListPrograms,EqualToCondition,[Active List].[Programs],String), RSCustomDaxFilter(@ActiveListArlocDesc,EqualToCondition,[Active List].[Arloc Desc],String), RSCustomDaxFilter(@ActiveListPhase,EqualToCondition,[Active List].[Phase],String), RSCustomDaxFilter(@ActiveListProjectManager,EqualToCondition,[Active List].[Project Manager],String), RSCustomDaxFilter(@ActiveListProjectNumber,EqualToCondition,[Active List].[Project Number],String), "Current Status", [Current Status])Calling a Reporting with parameters from an appkication doesn't work
Hello Community, my client uses Power BI report Server Version1.22.9153.7886(Januar 2025). We call reports like reports/powerbi/.../Artikelstatistik?rs:embed=true&filter=Gesamtumsatz/Artikelnummer eq '03008' which works, but it doesn't work with vm57/reports/powerbi/.../Artikelstatistik?rs:embed=true&filter=Gesamtumsatz/Artikelnummer eq @@Artikelnummer', which worked well before. (May 2024). Thanks and Regards Walter
Page Break on Common Field with Two Tables
I'm attempting to create a report that has the following properties: Uses data from Power BI Semantic Data Model Combines data from two fact tables (1. survey responses and 2. site notes) and two dim tables (1. suppliers and 2. negotiation issues) Has two tables on each page, one dedicated to each of the fact tables Page breaks on the negotiation issue and has both tables on a single page Ideally, users would select a supplier (only ever one) and a negotiation issue (either one, multiple, or all) and a report would be created that has both the survey responses and the site notes on one page broken up by negotiation issue. The supplier and issue are parameters selected from DIM tables, and each table has filters to only return data for the parameter selections. The problem I'm running into is the page break will split up all the notes first and then all the survey responses, but I'd like the notes and survey responses for each negotation issue on one page before page breaking to the next issue. Below is an example of my current report: Is this possible? Any advice is appreciated.
Add parameter in query designer (query from Power BI Performance analyser)
Hi guys, I am trying to add a parameter in my report and add the parameter in the query designer module. The query was generated within Power BI via Performance analyser. I saw different posts on this issue but no clear solution. First I have tried to create a parameter in the report (in my dataset properties) and add it with @ in my query such as // DAX Query DEFINE VAR __DS0FilterTable = TREATAS({@Test}, 'FACT - Conflicts'[Conflict category]) However, I have an error message that the parameter test was not declared. So I declared it again through "Query Parameters" module within the query designer (same name and another name). This time I can execute the query but it returns no row with a default value "Group" (which should not be the case - if I had put TREAT({"Group"}, it returns some rows). I tried to see what were the values in the Parameters properties window and I can see this. Which I don't understand because "Test" is not the name of my dataset.. Any idea to resolve this? Thanks a lot in advance!
PBI Report Builder - removing duplicate values in parameter dropdown
I'm currently working through building a paginated report with PBI Report Builder, but a small issue came up. One of my parameters is called Spend Year. Currently, for the sake of working with a faster loading file, I filtered this down to only include the year 2023. However, the issue with this is that the parameter dropdown is displaying multiple options for 2023. I believe it's displaying a 2023 for each row in the dataset that contains one. Having multiple options for the same thing just isn't practical, so I've been looking for a way to have the parameter dropdown display distinct options. I managed to find this article: https://www.c-sharpcorner.com/article/remove-duplicate-filter-values-from-ssrs-parameter-drop-down/. While this matches my situation, the VB code that he writes is for String values. I'm working with integers. I tried my best to adapt his code to work for integers (you can find the code below), but after following through everything, my Spend Year parameter is now greyed out with no selectable values. I was sure to configure the available values as detailed in the article. Does anyone happen to have any idea how I should go about this? If it's useful to know, my data was pulled via a DAX query. Thank you in advance! My version of the code: Public Shared Function RemoveDuplicates(parameter As Parameter) As Integer() Dim items As Integer() = parameter.Value Array.Sort(items) Dim k As Integer = 0 For i As Integer = 0 To items.Length - 1 If i > 0 AndAlso items(i) = items(i - 1) Then Continue For End If items(k) = items(i) k += 1 Next Dim unique As Integer() = New Integer(k - 1) {} Array.Copy(items, 0, unique, 0, k) Return unique End Function
Report Builder - Paginated Report - Parameter with Power BI Dataset Connection
Hi, I need to set up a parameter. I've been following the instructions in this article, but it doesn't cover parameters. In Report Builder, I have connected to the data source which is a dataset in a Power BI Service workspace. In Desktop I built a table visual then copied the DAX from performance analyser. In Report Builder, I created a dataset using the copied DAX. The issue is I cannot get a Parameter set up in Report Builder. I have created the parameter p_Shift under Parameters and chosen the relevant field 'Site'[Site Code] from the dataset. In the dataset under the Parameters tab, I have added the created parameter. I know the the third step is to go back to the query tab and add a clause to match the field to the paramter. In SQL this would be WHERE 'Site'[Site Code] = (@p_Shift) . But I can't find information to say what it sould be in DAX, or where in the query to place the clause. Thank youStop Parameter container from hiding when returning from child report
Hello, We are displaying SSRS reports in Power BI Report Server. Few reports have child reports created, now, after opening the child report and pressing the "Go back to parent report" button (to left of zoom drop-down), I will be taken back to the parent report, but the Parameter container will be hidden. Is there a way to keep it always visible? Is it something that can be controlled from SSRS?Let enduser control fonts i embeded solution
I have a customer the wants to know if it's possible to let an end user of an Web application which embeds a power bi report server report to controll the Fontsize, -color, -type in tables, headings and so on. From what I can find in the documentation there is no way of doing this by passing in parameters or any other way. Have anyone done something similar?
