Power Query very slow when combining hard credit and soft credit data from Fabric Warehouse
I’m working in Power BI Desktop with data coming from a Microsoft Fabric Warehouse. I have two related tables: B_Gifts - contains Gift ID, constituent ID, gift amount, gift date, etc. B_Gift_Soft_Credits - contains Gift ID, soft-credit constituent ID and soft-credit amount. The business requirement is to create one set of giving records where a constituent can receive either hard credit or soft credit for a gift. If the same constituent receives both hard and soft credit for the same Gift ID, I need to count the gift only once, using the maximum credited amount. My current Power Query approach is: Hard-credit query → create Credited Constituent ID and Credited Amount Soft-credit query → join back to Gifts by Gift ID → apply the same gift filters/fiscal-year logic → create Credited Constituent ID and Credited Amount Append both queries Group by: Gift ID + Credited Constituent ID + Fiscal Year and calculate: MAX(Credited Amount) The problem is performance. The hard-credit query is around 49,000 rows and the soft-credit query around 43,000 rows. The final Append/Group By can run for a very long time or fail to complete. I also tested the logic on one constituent only. The visible result was only a few hard-credit and soft-credit rows, but Apply Changes still spent a long time waiting on the Fabric Warehouse connection. I confirmed that my Fabric credentials are valid and I am signed in correctly. My questions are: Is this better handled in Power Query, DAX, or Fabric SQL? Could referenced queries or lost query folding be causing Power BI to reprocess much more data than the filtered rows suggest? Would you recommend creating the hard/soft-credit union directly from the two source tables instead of referencing existing queries? What is the best way to diagnose which Power Query step is causing the delay? I’m trying to keep the business logic reusable because the result will feed both annual and monthly donor-giving tables.Power Query Editor - Using the 'Go to column' search feature
Power BI Desktop: Version: 2.158.1304.0 Problem: Power Query Editor - Using the 'Go to column' search feature, the PBI screen focus and desired column is not highlighted. The app focus does not move to the search filtered column, if you filter the column names and select the column from the 'Go to column' dialog. Background context: Desired column selection in dataset: 'Discount'. The column exists in the field set. Using the same 'Applied step'. Open the 'Go to column' dialog. Type the column name into the Search text box to filter the list and select the column from the results. The screen focus does not change. Discount column is NOT highlighted and not in focus. Reopen the 'Go to column' dialog and do NOT filter using the 'Search' text box. If I manually scroll through the list of columns and select the column using the dialog vertical scrollbar, then press the 'OK' button, the expected column focus functionality is achieved.
How can i Join (create relationship) multiple tables in Power BI
Dear Team, I am reaching out to you to requested your support in linking (Join) these three tables. In fact, I would like to link (join) these three tables in order to carry out the following analyses: - Number of projects recorded per cluster - Number of projects reported per cluster - Number of projects recorded by Admin1 - Number of organisations (T_Organisation) recorded by Admin1 - Comparison of recorded projects and reported projects by cluster - Comparison of recorded projects and reported projects by Admin1 Note: The Cluster column in the tables (T_Project and T_Reporting) is a multi respons column with values separated by commas. Please see the snapshot below and enclosed the Excel file as an example.
