Issue: can you adjust the browser Power BI desktop uses to login to salesforce?
We are trying to connect Salesforce reports using Power BI Desktop. When we are prompted with the salesforce login we use custom domain, and then use SSO login. We are getting an error when logging in that way. We get the same error when trying to login to salesforce through an IE browser. Is there a way to adjust the browser Power BI desktop uses to login to salesforce?Global Text Search and Filter Across All Tables in Power BI
Greetings, Currently, couldn't find a method to enable users to search through every column in every table for a particular text string and promptly filter visuals on the page with corresponding results (Acting like a Search Bar). While workarounds like concatenating columns exist, they're inefficient and impractical for large datasets. Any enhancement facilitating this capability would greatly enhance efficiency and empower users to efficiently delve into their data. Thank you.
Pagination not working correctly with filtering/search in Power BI table (data exists but appears on
Hi everyone, I am new to Power BI and currently learning by building a Worker Status Report. I am facing an issue with custom pagination when filtering/searching data. Report Setup Data source: PostgreSQL Data is retrieved via a database VIEW Visual: Table Page size: 40 rows per page Pagination implemented using DAX + slicer Filters: Date slicer (range) Search (Company / Department / Employee / Team Leader) The data exists in the model, and both date filter and search work, but the issue is with pagination. When I apply filters or search: The table sometimes shows 0 rows However, the filtered data is actually present on page 4, 5, or some other page Pagination does not reset or dynamically adjust based on the filtered result As a result, users think there is no data even though it exists What I expect: Pagination should recalculate dynamically based on filtered rows If filtered data has fewer rows, page count should update automatically Filtered results should appear on page 1, not hidden on later pages Dax used for navigation page navigation table Page Navigation = VAR totalrows = COUNTROWS(vw_worker_status) VAR _pagesize = 40 VAR totalpages = CEILING(DIVIDE(totalrows, _pagesize), 1) RETURN ADDCOLUMNS( GENERATESERIES(1, totalpages, 1), "Min", ([Value] - 1) * _pagesize + 1, "Max", MIN([Value] * _pagesize, totalrows) ) Pagination measure slicer selection = VAR minvalue = SELECTEDVALUE('Page Navigation'[Min]) VAR maxvalue = SELECTEDVALUE('Page Navigation'[Max]) VAR indexvalue = SELECTEDVALUE(vw_worker_status[index_col]) RETURN IF ( indexvalue >= minvalue && indexvalue <= maxvalue, 1, 0 ) This measure is applied as a visual-level filter (= 1) on the table. My Question Why does pagination not adjust when filters/search are applied? How can pagination be made dynamic based on filtered rows, not total rows? Is there a better or recommended approach for pagination in Power BI tables? Should COUNTROWS be replaced with a filter-aware calculation (like ALLSELECTED)? I would really appreciate guidance or best practices. Thanks in advance for your help! https://drive.google.com/file/d/1DjHwOcX_bGAFqFlIzVC-YEXBzbYqHrBh/view?usp=sharingWhy does the Emissions Impact Dashboard stay on sample data after setup?
Hello, I followed the instructions in the article: Connect to the Emissions Impact Dashboard for Azure - Power BI | Microsoft Learn I installed the Emissions Impact Dashboard for Azure and, as described in the steps, I entered the billing account ID from Connect your data. My account has already been assigned the Billing Account Owner role. However, my Azure environment is a free trial, not an Enterprise Agreement subscription. After that, the “Connect your data” button disappeared, which made it look like the connection succeeded. But the dashboard content still only shows the sample data. The documentation says: "Wait for the view to build, which can take up to 24 hours. Refresh the dataset after 24 hours." I waited more than one day, but nothing has changed. Additionally, this might not be related, but when I go to the Manage data tab and click Delete data > Confirm, I get redirected to the page shown in the third screenshot. Why am I unable to see my own Azure emissions data in the dashboard? What could be the issue? (Could it be because my environment is a free trial, not an Enterprise Agreement?) If anyone knows the cause or any workaround, I would greatly appreciate your advice.
way to Find out Ticket support engineers
Hello, I'm using Powerbi as a paid plan. There are many errors, so I would like to ask . I'd like to know the detailed route for your inquiry. https://support.fabric.microsoft.com/ko-KR/support I went in here and tried, I can't see the button to make a ticket like image 1. If you log in, you'll only be taken to https://app.fabric.microsoft.com/home .Dynamic Inventory Reconciliation: Aligning Opening and Closing Balances in Power BI
I have created an Inventory Reconciliation report that includes a Year slicer. The report's main visual is a matrix with the following rows: Opening Inventory Purchases Sales Closing Inventory (Calculated) On-Hand Quantity The Closing Inventory (Calculated) is determined using this formula: Closing Inventory (Calculated) = Opening Inventory + Purchases - Sales The matrix has Months set on the Columns. For example, if the year 2023 is selected: January’s Opening Inventory is calculated using the following DAX formula: Opening Inventory (Q) = CALCULATE( [On-Hand Qty], PREVIOUSMONTH('Calendar (On-Hand)'[Dates]) ) For February, the Opening Inventory should use January’s Closing Inventory (Calculated) or the previous month's Closing Inventory. Currently, the Opening Inventory row uses its formula to calculate results, which might lead to inconsistencies. I believe the Opening Inventory should instead depend on the Closing Inventory (Calculated) from the previous month. What would be your solution?
Custom Sorting in PowerBI?
Hello all, Seeing as how helpful people were with my last two questions, I thought I'd ask another, which has been nagging me. I'm aware of the sorting function in graphs, but that seems to sort the items alphabetically. What I'm hoping to do is sort non-alphabetically, in an order that makes sense otherwise - highest to lowest, or whatever the case. See here: I'd like it to read Critical, High, Medium, Low. Is there anything I can do here? Thank you!
Issue with Including Zero Counts in Average Calculation Measure in PowerBI
Hello, I’m encountering an issue with a measure in PowerBI where I need to include zero counts in an average calculation. My current setup involves calculating the average number of sessions per CP ID, but I’m finding that the measure incorrectly excludes zero counts when a CP ID has no sessions on a particular date. (My data is regarding EV charging sessions) Here is my current set-up: 1. A measure to work out the average number of sessions per charger: SDR ID average per CP ID = AVERAGEX( KEEPFILTERS(VALUES('Pogo E Connect Data'[CP ID])), CALCULATE(COUNTA('Pogo E Connect Data'[SDR ID]))) 2. A measure to work out the average number of session dynamically using a customer Calendar table: Average Number of Sessions.1 = AVERAGEX( SUMMARIZE( 'Calendar', 'Calendar'[Year], 'Calendar'[Quarter], 'Calendar'[Month], 'Calendar'[Date], "Average Sessions", CALCULATE( AVERAGEX( VALUES('Calendar'[Date]), COALESCE([SDR ID average per CP ID], 0) ) ) ), [Average Sessions] ) My ultimate goal is to work out the Average number of sessions per charger per day. However some chargers do not have sessions everyday, which I tried to handle with COALESCE([SDR ID average per CP ID], 0), but frankly it just doesnt care and disregards the days without sessions. For example, on 18th June: Charger 1 = 3 sessions Charger 2 = 4 sessions Charger 3 = 0 sessions The measures are returning an average of 3.5 sessions, while the correct average should be 2.3. Does anyone have any ideas on how I could resolve this issue? I need to ensure that days with zero sessions are included in the average calculation. Any help or suggestions would be greatly appreciated!
