Github PowerBi connector - JSON error

Hi, ferryv 

Regarding the issue you raised, my solution is as follows:

1.Firstly, regarding your GitHub connector, it is still in the development stage, so there are some issues at present. You may encounter warnings when using the GitHub connection:

2.Secondly, concerning the error you mentioned, “references other queries or steps, so it may not directly access a data source,” you can try merging multiple queries into one. Here is a screenshot of the relevant response:

Solved: Query references other queries or steps, so it may... - Page 2 - Microsoft Fabric Community

You can also try ignoring the privacy levels:

Chris Webb's BI Blog: formula firewall (crossjoin.co.uk)

https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

3.Lastly, regarding the issue of “removing or ignoring comments and then invoking the step,” you can try creating a notebook in Lakehouse and then use the json.loads() function in Python to parse the JSON data

https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-data-gateways#personal-gateway

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.