Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I am trying to code a RelativePath for a URI so I can use schedule refresh in the PowerBI Service, however in Power Query I get the error "Expression.Error: Access to the resource is forbidden." when testing out the RelativePath method. Any ideas for why RelativePath is not working here?
Here is my code from the error:
let
Test = Web.Contents("https://files.xxxxx.gov/generated_downloads/All_PrimeTransactions_",
[RelativePath="2022-11-21_H13M48S59799377.zip"])
in
Test
Here is the same URI without RelativePath that works:
let
Test = Web.Contents("https://files.xxxxx.gov/generated_downloads/All_PrimeTransactions_2022-11-21_H13M48S59799377.zip")
in
Test
Solved! Go to Solution.
I found the issue, the RelativePath function adds a "/" before the text, so I needed to adjust which part of the URL was in the RelativePath function.
@Anonymous , Refer if this blog can help
I found the issue, the RelativePath function adds a "/" before the text, so I needed to adjust which part of the URL was in the RelativePath function.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 49 | |
| 44 | |
| 42 | |
| 39 | |
| 32 |