When publishing the Team Forms PowerBI template, you may experience the following issue:
This dataset includes a dynamic source. Since dynamic data sources aren't refreshed in Power BI service, this dataset won't be refreshed.
To make the template as easy to use as possible, the PowerBI template provides the flexibility for new users to enter SharePoint URLs in any format. Unfortunately, this step is interpretated by PowerBI as a dynamic source.
You can resolve by following the steps below:
In the "Data" sidebar on the right of PowerBi Desktop right click any of the data sources and click "Edit query". This will open the query editor window
Click the "GetTeamFormsData" function then "advanced editor" in the home ribbon.
Using the advanced editor replace the function all on line 12 with a hardcoded string of your SharePoint URL in the following format:
siteUrl = "https://myorganisation.sharepoint.com/sites/MyTeamName",
