Power BI refresh fails with Status Code 400

[jaysel]

The dataset scheduled refresh fails when I use OAuth/Org with the below error. I am able to refresh it without any issue from my Desktop.

Additional Info:

This has impacted to many other users using the same Data Lake with same use case

These reports have been functioning for quite some time not a new report.

Access to the Gen2 endpoint is managed through a Security Group, where other SPN's are used, and there is no issues with accessing through SPN.

We have a wide range of users impacted because of this.

The issue is suspect is some where with AAD auth for PBI Service.

Power BI refresh fails with Status Code 400

Failed to update data source credentials: AzureDataLakeStorage failed to get contents from 'https://foo.dfs.core.windows.net/eue/foo/foo/foo/foo.tsv/https%3A//foo.dfs.core.windows.net/eue/foo/foo/foo/foo'. Status code: 400, description: 'The request URI is invalid.'.Hide details

Activity ID:	e35924b2-39cd-404c-9ad0-b0338aa7b2a5
Request ID:	81797554-7cdd-d12d-f3b2-0fa800b6bd96
Status code:	400
Time:	Thu Sep 30 2021 11:44:54 GMT-0700 (Pacific Daylight Time)
Service version:	13.0.16934.40
Client version:	2110.1.07937-train
Cluster URI:	https://df-msit-scus-redirect.analysis.windows.net/

[ursengar]

We are seeing similar issues (Power BI refresh fails with Status Code 400) on our Power BI dashboard. We are able to refresh the report using Power BI Desktop Version. Please look into this on priority as it is impacting our customers.

[v-robertq-msft]

Hi, 

If you want to get a solution for this kind of refresh problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin