Parameter in Power BI report Builder
Hi All - I'm facing an issue where Report Builder connected to a Power BI Semantic Model is returning multiple rows. To resolve this, based on this thread I created DAX from Performance Visualiser. There is no mention of how to insert parameters in the above thread. But using this thread I could find how to do it. But when I follow it, I get the error saying the Parameter X is not defined. I've looked at below solutions, but nothing works Pass a Parameter to DAX Query Report Builder - Stack Overflow Chris Webb's BI Blog: Power BI Report Builder And RSCustomDaxFilter Re: The Query contains the "XXXX" parameter, which... - Microsoft Fabric Community Dynamic Parameters in PBI Report Builder using a p... - Microsoft Fabric Community Solved: Bug: Power BI Report Builder - Parameter Not Decla... - Microsoft Fabric Community All I need is, if I'm using the DAX provided by Performance Analyser in the report builder, what is the syntax for that query to use Parameters. Thanks
Power BI Report Builder Sign In Error: An error occurred while sending the request
Hi has anyone encountered this error before and solved it? I get the failed to sign in, an error occurred while sending the request error when I try to sign into Power BI Report Builder. I am able to log into Power BI Service and Power BI Desktop no problem.
Power BI Report Builder_ Failed to preview report
I am trying to build a paginated report on Power Bi report builder. I have a valid stored procedure on my SqlServer DB. To keep the consistency of the design ( formatting, colors, text aligning) I created a copy of the existing report and deleted the dataset which was in it. And added my own dataset. Deleted the tablix column content from the existing report copy and filled the columns with my datasets columns. But when I run the report, it shows: " The hidden expression for the textbox 'Textbox11' has ascope parameter that is not valid for an aggregare function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset". Did anybody come accross this issue in the past? How could you solve it?Paginated report embedded for your customer, RLS and CUSTOMDATA()
Hello, I'm using Power BI Premium and additional web application with its own authentication. I have published Power BI report and I am using service principal to communicate Power BI service wit web application. I am passing a parameter from web app to PBI service to know, who is logged in and I am reading that information using CUSTOMDATA() for RLS purposes. It works perfectly well. However, I have published Paginated Report with very same set up and it turned out CUSTOMDATA() retreives null, USERPRINCIPALNAME() and USERNAME() both retreive my login as a report publisher for each logged in user and built in (native) Report Builder function UserID retreives the same string for each logged user as well (it may be my GUID). Question: How to retreive in Paginated Report who is logged in to web app? How to get the same information like CUSTOMDATA() in Power BI but in Report Builder? ThanksHow to define Date Range for Parameters in Report Builder
Hi, I have a request to have a date range filter based on submission date in a paginated report, I am able to create the date range and it's working, however the report has only 3 years worth of data and the date range showed in filters displays all possible dates from 1800s, so users can select older dates although there's no data for those dates. I am trying to limit the date range filter to the relative dates in the dataset but I can't figure a way to do that. My paginated report is connected to a PBI dataset so I am using dax. This is my query ----------------------------------- DEFINE MPARAMETER s_start_dt = FORMAT(@s_start_dt, "MM/dd/yyyy") MPARAMETER s_end_dt = FORMAT(@s_end_dt, "MM/dd/yyyy") VAR __Table1 = SUMMARIZECOLUMNS( Query1[Category], Query1[Aggregate Underwriting Comp], Query1[violation_id_link], FILTER(VALUES(Query1[sbmsn_dt]),Query1[sbmsn_dt]>= @s_start_dt && Query1[sbmsn_dt]<= @s_end_dt) ) EVALUATE __Table1 ORDER BY Query1[sbmsn_dt] desc -------------------------------------------------- the parameters are defined as Date/Time with no available values nor default values Below is a screenshot of how I see the date rnage right now, any help would be appreciated! I have also tried the usual way where I add a calendar data source with relative dates (min and max based on my dataset), but this displays 2 boxes in the report for "From" and "To" Dates with dropdown to choose the date (like a dropdown text) which is not very intuitivePassing parameter in Paginated Report
Hello, I have created 5 paginated reports in Report Builder. All of them contain tables only and few multiselect parameters. In the first report you can select particular row and click it, report will pass all values from all parameters to the 2nd report. On the second report you can click and 3rd report opens and so on. I'm passing parameters values in URL however the limitation of that solution is that URL cannot be longer than 2000 characters and this is my issue. I would like to set it up like this: user can select all values in all parameters but when user clisks on particular row, report will grab only related to that row values and pass only those singe values into parameters to the next report instead of passing all parameters values. Is it possible? 🙂 Thanks
