There are some nice improvements to Power Query integration in the latest version of Power BI Report Builder that, while they are documented, didn’t get an official blog post but which I think deserve to be highlighted. First of all the “Get Data” button has been renamed “Power Query”:
Secondly, and most importantly, there’s a new custom property tab for Power Query datasets:
As well as showing the M code used for the dataset (at the top) and a list of any M parameters (at the bottom), you can now see the ID of the Cloud Connection used by the dataset in the middle of the pane, copy it, and then press the manage button to go to the “Manage Connections and Gateways” pane in the Fabric portal, paste the ID into the search box and find the Cloud Connection used by the dataset, so you can edit it or refresh the credentials if you need to:
As a Power Query fan I have always been a big fan of its integration in Report Builder and this makes it much easier to use.