What's happening
Your Power BI file is connected to Flowsite but the data is not updating when you click Refresh, even though new forms have been submitted in Dashpivot.
Why this happens
The cached credentials in Power BI have expired or been cleared
The connection between Power BI and the Flowsite flow URL was broken after a Power BI update or crash
The Flowsite flow URL in Power BI's Data Source Settings no longer matches the current flow URL
The Flowsite flow has not been triggered since the last time data was loaded, so there is no new data to pull
A corporate firewall or proxy is blocking Power BI from reaching the Flowsite hosted file URL
How to fix it
Fix 1 — Trigger the flow manually in Flowsite
Before refreshing Power BI, make sure the flow has run and has new data available.
Log in to Flowsite and go to the Flows tab
Locate your flow and click Trigger flow manually
Wait for the run to complete, then go back to Power BI and click Refresh
Fix 2 — Reconnect your Flowsite credentials
If triggering the flow does not resolve the issue, clear and re-enter your credentials.
In Power BI, go to Home > Get Data (dropdown) > Data Source Settings
Select the Flowsite URL and click Clear Permissions, then close the window
Click the dropdown next to Transform Data and select Transform Data to open Power Query Editor
Select the query and click Refresh Preview
When prompted, click Edit Credentials
In the Access Web Content window, select Basic, choose the URL containing "nod" from the dropdown, enter your Flowsite credentials, and click Connect
Click Refresh Preview again, then click Close & Apply
If typing your credentials manually instead of pasting them resolves the issue, extra spaces may have been causing the connection to fail.
Fix 3 — Update the flow URL if it has changed
If the Flowsite URL in Data Source Settings does not match your current flow URL, update it before reconnecting.
In Power Query Editor, go to Applied Steps and click Source
In the formula bar, click Change Source… and enter the correct flow URL
Proceed with the credential steps in Fix 2 from Step 4
Fix 4 — Check for a firewall or network restriction
If the data URL is reachable in a browser but not in Power BI, or if the issue only occurs on your work network, a corporate firewall may be blocking access to the Flowsite hosted file storage.
Copy the Flowsite flow URL and paste it into a browser — if it prompts for credentials or returns data, the URL is accessible and the issue is Power BI-side
Try refreshing from a different network (such as a mobile hotspot) to rule out a firewall restriction
If the issue only occurs on your work network, ask your IT team to allow access to sitemate-flowsite-hosted-files-production.s3.ap-southeast-2.amazonaws.com
Notes
Flowsite hosted sources are designed for use with Power BI Desktop. Power BI Online Dataflows (Gen1) are not supported — if you are using Power BI Online Dataflows and experiencing recurring authentication failures, this is a known limitation.
If data appears after some time but not immediately after refreshing, wait a few minutes after the flow has completed its run before refreshing Power BI.
If you want Power BI to refresh automatically on a schedule without opening the file manually, this requires a Power BI Pro or Premium subscription (or a Microsoft 365 Business plan that includes Power BI). Pro allows up to 8 automatic refreshes per day; Premium allows up to 48. This feature is not available on a free Power BI account.