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.
Calculate variance between two Matrix in Power Bi
I have two matrixes in power Bi user can choose a forecast from point in time and select which month to see the results. from 1st slicer they choose the first creation date (year and Month) then they choose which month to see the forecasts for in the 1st matrix same for the 2nd matrix for a different point in time so, we end up with two matrixes. how can I calculate the variance between these two matrixes? Thanks results
I am getting the following memory limit error in PowerBI report
When I opne the PowerBI report I am getting the following Memory limit issue. May I know what could be the possible reason for this? I also having issues loading data to the visualizations as it takes very long to load data to visuals. I'm new to Fabric and may I know how I can rectify this issue.
Page Breakup in Power BI Report Builder
Hello, I have a vertical Bar Chart in my paginated Report and because this chart is very long, it is split up over many pages. The Problem that I have is, that at the Split up happens right through the charts / labels. How can i change this? PowerBI,@SSRS, sql
Problem with My Custom Visual in Power BI
I've developed a DatePicker visual for Power BI, but I'm facing an annoying issue that affects user experience. When users interact with the report, my visual keeps flickering between showing the selected date and showing "Select period" (the no-filter state). This rapid alternation between states happens most noticeably when users select a date or click the "Clear filters" button in Power BI. The root cause seems to be that my visual receives multiple contradictory updates from Power BI in quick succession. One update tells the visual that filters are applied, then immediately another update says no filters exist, then back again to filters being applied. This creates the flickering effect as my visual tries to respond to each update. I'd like to know if this behavior is normal in Power BI or if there's a recommended way to handle these contradictory updates. Is there a technique to make my visual display a consistent state? Also, is there a reliable way to detect when a user has clicked the "Clear filters" button? Any help or suggestions from those who have encountered similar issues would be greatly appreciated.
DAX Lookup Value in another table with filter (calculated column)
Hi all, I have the following tables, relationships and data: Project: Task: ProjectPhaseSummary: I want to add calculated columns to "ProjectPhaseSummary", so that I end up with the following: Hoping someone can please suggest the most accepted way of generating the information above with DAX (preferably using CALCULATE). Thanks, Ben.
Can you use a tooltip in a table to display description
Is there a way to show additional data in a table for one field IF the field has conditional formatting to display a YES or NO? In the screenshot below, the Go to Green plan would have either a Yes or No displayed. The Yes, when clicked on or hovered over would display data pertaining to that project. Is this possible through tooltips? Table with Yes/No When Yes is selected or hover over, it would display the detail for that project.
