Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a report where I get the data from a repo using Github Api. The repo is public so there shouldn't be any credential required but still used basic authentication method to get the data (I tried it without credential also). This repo has over 1000+ issues, it was working well until two weeks ago and now suddenly I have started getting the following errors:
OLE DB or ODBC error: Exception of type 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenEx
OR
Access to the resource is forbidden.
//Function
(page as number) as record =>
let
Source = Json.Document(Web.Contents("https://api.github.com/search/issues?q=repo:ORG/RepoName&page=" & Number.ToText(page))),
Data = Source
in
Data
let
fd = GetData(1),
//30 because Github gives 30 records only per request
pages = Number.RoundUp(fd[total_count]/30)+1,
Query2 = List.Generate( () =>
[Result= try GetData(1) otherwise null, Page=1],
each [Page] <> pages,
//each [Result] <> null,
each [Result = try GetData([Page]+1) otherwise null, Page=[Page]+1],
each [Result]
)
Thanks for your help in advance.
Hi @smerchantkitab ,
You could create a support ticket to get the dedicated support. And please share the solution here when you resolve the issue. More people who encounter the same problem will benefit from this thread.
Thanks. Unfortunately, I am not a Pro user and I see lot of related issue on the forum but no one has provided a confirm solution for this issue and surprising there is no solution or workaround provided by Microsoft.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |