Power BI Service Data Refresh Issue

[TeddyWW]

I have a dataset and contans seveal queries (get data from web by using web.browserconants).

The Refresh is power bi desktop is working fine.

But in Power BI Service there are some wired issue.

If the dataset only have one query from web then 90% times were ok of refreshing.

If the dataset have 2 or more queries from web then it was always failed of refreshing.

The tables in the webs are really small and simple.

Could someone help me 🙂

error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We timed out waiting for the web page to load."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://www.stats.govt.nz/topics/housing"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: New dwellings consented.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: eeadd1b1-7f35-43c4-9e54-5a2ce3b12635
Request ID: a5ec9169-9a55-4b52-a858-c11019ed0fcb
Time: 2023-10-09 09:32:41Z

[Anonymous]

Hi @TeddyWW ,

Have you tried adjusting the privacy level settings? Change the privacy level in Power BI Desktop and then republish the file to the Power BI service.

Remember to always ensure that basic requirements for refresh are met and verified:

1.Verify the gateway version is up to date.
2.Verify the report has a gateway selected. If there is no gateway selected, the data source might have changed or might be missing.

Best regards.
Community Support Team_Caitlyn

[TeddyWW]

Thank you for your respond!

I am still having this issue.

I created a new dataset and only linked 2 simple web data sources. All in Orgenazational Pravicy in Desktop and Service. Gateway is new downloaded and installed.