Power Automate- Power BI- Error with Query Text- 400 not found

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:

Mine did not have a connection there.