Github Issue Api 'Microsoft.Mashup.Engine.Interface.ResourceAccessForbiddenEx

[smerchantkitab]

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.

I have cleared the credential and added it back, tried it with the older version of PowerBI etc, but nothing helped.  In the query editor, I can see the number of rows correctly load, but when apply changes it doesn't work. 

I wonder if I am doing anything wrong to fetch the data.  Here is the code:

//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.

[v-xuding-msft]

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.

[smerchantkitab]

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.