Scheduled refresh for AWS-hosted database without connecting VPN every time
Hi everyone, I have a dashboard published in Power BI Service, connected to our company database hosted on Amazon AWS (RDS). The database is only reachable when I’m connected to the company VPN, so I have to connect the VPN every time I refresh the data. I have already installed an on-premises data gateway. Goal: Set up scheduled refresh in Power BI Service so the dataset refreshes automatically without anyone connecting to the VPN manually.
PBIRS On-Premises Licensing, Website Embedding, and SSO Requirements
Hi Team, I need some guidance on a client requirement involving Power BI Report Server (PBIRS). The client wants to host reports entirely on-premises (no cloud & Internet dependency) and embed them into a website built using React.js and NGINX. Could you please help clarify the following? Licensing: What licenses are required for PBIRS, including report viewers? Embedding: Is embedding PBIRS reports in a React.js website behind NGINX supported, and what is the recommended approach? Authentication/SSO: Can users who have already logged into the website access embedded reports without being prompted for separate PBIRS credentials? Integration: If the website uses its own authentication mechanism, can it integrate with PBIRS SSO? Are any additional configurations or custom components required? Security: How should user permissions and report access be managed securely? Please share the recommended architecture, any limitations, and relevant Microsoft documentation to help us determine the feasibility of this solution. Thanks!
Paginated Report fails to render when chart drill through contains large multi-value selection
Hi all, We are using a Power BI paginated report with a Chart visual. Each chart data point has a Drill through action configured to open a sub report. One of the drill through parameters passes a multi-value report parameter using: =Join(Parameters!IP_PARAM.Value, ",") The report works when a small number of values are selected. However, when the user selects a large number of values (for example, Select All across 50+ clients), the MAIN report fails during rendering with: "Unable to render paginated report... The generated drill through URL for the Chart 'Chart1' is too long. The maximum supported URL length is 65,535 characters." The important point is that the user has NOT clicked the chart data point. The error occurs while the main report is rendering. We would like to understand whether the drill through URL and its parameter expressions are expected to be evaluated/serialized during rendering of the source report. Is there a supported way to defer evaluation of the drillthrough parameter until the user clicks the chart data point? Also, is there a supported way to pass a large multi-value selection to the drillthrough report without serializing all selected values into the generated URL? PFA.. below image is with select all below image is with few values selected in the parameters Thanks.
Report Builder Paginated report w/ 2 datasets sharing common Parameters issue
I have a Paginated Report (I am using a tabular model from our analysis server) question as I have 2 datasets joined by a common Parameter which is the DateColumn MonthYear- I have these referenced inside both datasets like so: (dataset1 uses both parameters for filtering but I want dataset2 to only use the date filter) Dataset1 has YearMonth and PhysicianOrg parameters but Dataset2 only has YearMonth as we do not need the PhysicianOrg parameter for Dataset2. I have a total of 4 datasets from the same source. Dataset1 will be filtered by both Physician Organization and Date (monthly reporting) and DataSet2 will only be filtered by YearMonth. I created 2 new tables for both Parameters (YearMonth and PhysicianOrg). Dataset2 only references the yearMonth parameter which is what I want as I wish to COMPARE the OVERALL score to the score which will be filtered by both YEARMONTH and PHYSICIANORG. When I add a new table and reference dataset2 along with dataset1 in one table it does work. I tested this expression from Dataset2: =Lookup(Fields!YearMonth.Value, Fields!YearMonth.Value, Fields!ID_AllowedPMPMYTD_.Value, "DataSet2") AND =SUM(Lookup(Fields!YearMonth.Value, Fields!YearMonth.Value, Fields!AllowedPMPMYTD_2.Value, "DataSet2")) and it does NOT WORK. (the numbers are not matching the excel formula which is =IFERROR(CUBEVALUE("Cube",GM,CubeMeasures!$D$25,CurrentMonth),0). (the current month is hardcoded and referenced I tried this expression inside the same table and referenced Dataset2 but that did not work. I am trying to match an excel formula report which uses HFPN overall is just AllowedPMPMYTD =CUBEMEMBER("Cube","[Measures].[AllowedPMPMYTD]") (it filters by month using How is this matched in Report Builder??? Do I need to use a DAX variation of CURRENT MONTH? I use the formula below sliced by yearmonth (SQL via Tabular Model) in Report Builder: The question is how do I show both results from 2 datasets in one paginated report? I just need one column with the same expression to filter differently: The Rate Column Filters by both parameters and the HFPN column filters by yearmonth column. Any suggestions? I created dataset2 just for HPFPN overall which I am currently hard coding until I can work this relatively simple problem out. EVALUATE SUMMARIZECOLUMNS('Providers'[PCPLocation], 'Providers'[PhysicianOrganization],'DateDim'[Year],'DateDim'[MonthNameAbbreviation],'DateDim'[YearMonth], FILTER(VALUES('Providers'[PhysicianOrganization]), 'Providers'[PhysicianOrganization] = @PhysicianOrganization),FILTER(VALUES('DateDim'[YearMonth]), ('DateDim'[YearMonth] =@YearMonth)), FILTER(VALUES('Patients'[Populations]), ('Patients'[Populations] = "GM")), "UniquePatients", [UniquePatients], "TotalCostYTD",
MS Gantt Chart Visual
I am using the MS Gantt chart visual. When I am creating in desktop, it interacts as it should with other visuals, but when I publish to my workspace to test it out, the interactions fail and the chart does not filter based on selections made within the other visuals. Can anyone provide some insight as to why?
