So this kept happening to me so I was messing around and this is how I fixed it.

I published my Power BI report so the Power Automate connector should have found it.

I had to find one more setting in my Power BI environment and it worked.

In Fabric (Power BI Online), on the left sidebar clink on "Browse".

Select your environment

Find your Report's "Semantic model" and click the three dots "..." to find more options.

Select "Settings"

Under Data source credentials, make sure there is a connections there. See below:

Hello all,

Ran into this today.

Make sure you "Query text" is changed to the number of rows you would like to get back. I think it defaults to 500.  I changed mine to 100,000. See below

Table.AddColumn(#"Grouped rows", "ITSPaymentFinal", each if [HHIDEarliestEntry] <= #date(2024, 12, 15) then 225 else if [HHIDEarliestEntry] >= #date(2024, 12, 16) and [HHIDEarliestEntry] <= #date(2024, 12, 31)then 187.5 else if [HHIDEarliestEntry] >= #date(2025, 1, 1) and [HHIDEarliestEntry] <= #date(2025, 1, 15) then 150 else if [HHIDEarliestEntry] >= #date(2025, 1, 16) and [HHIDEarliestEntry] <= #date(2025, 1, 31) then 112.5 else if [HHIDEarliestEntry] >= #date(2025, 2, 1) and [HHIDEarliestEntry] <= #date(2025, 2, 15) then 75 else 0)

If you are running into an issue that you inserted a "Text Input" box and all the sudden you do not have a "Text" property to write the search formula...

You inserted the wrong version of the Text Input.  There are two.

To get the .Text property for searching galleries, you need the CLASSIC Text Input. The other one is a Preview Text Input.

Sigh... 

Here's the code for the entire grouping that put all the Students grouped by House Hold ID. However I needed the first date that the first student entered the school district.

I think this could work for other Data Sources like dataverse as well.
Case Use: I used this to make sure duplicate appointment records did come over from the MS Bookings platform when I needed to do a large migration of the data  using power automate and the Microsoft Graph API.  Flow would bomb out and I think started again at the record it left off causing around 100 dups.

This flow helped me ID the duplicates and since there wasn't too many I went it and deleted in the list itself.  You could add a "Delete Item" action to this flow to do it for you.

Use case: Verify mailing addresses are valid with the Unites States Postal Services before mailing out large quantities of piece mail or check payments.  Thus reducing mailing returns.
In this flow I am doing a bulk address standardization. You would really only need to do that once and then maybe use an "Update" row after that.

First you will need a Smarty Streets account. You can try a trial version to test if this solution is best for you.

 Cannot be used as a child workflow because it is missing a response action

Follow these instructions

Add the action "Respond to a Power App or flow"

Add "Text" output

First Field: Status

Second Field: Done

Part 4

Power Platform Custom Connector
(I always build my stuff in Solutions, click here for more information about PowerPlatform Solutions)

1. Create and Name the Custom Connector

2. Scheme = HTTPS

3. Host is