Query: Power BI Custom Visual API Block – GPT/Gemini Integration Issue

[jesikamaurya]

I’m working on integrating ChatGPT or Google Gemini into Power BI using a custom visual to enable interactive AI responses directly from the report, based on the dataset contents.

Everything works fine when I test the API in Postman, but Power BI blocks the API call from the custom visual due to security restrictions, most likely related to Content Security Policy (CSP) or cross-origin (CORS) issues.

I’ve Tried So Far 

1. Built a custom visual in Power BI using React and TypeScript

2. Integrated OpenAI/Gemini API logic inside the visual

3. Created a proxy API server to forward the API requests

4. Used tunneling tools like:

   • Localtunnel

   • ngrok

   • Cloudflare Tunnel

But unfortunately, the API calls are still being blocked when the custom visual is rendered inside Power BI Desktop

I Need Help With

• How can I successfully connect Power BI custom visual to OpenAI/Gemini API through a proxy or tunnel?

• Is there a recommended tunneling or reverse proxy approach that works with Power BI visuals?

• Any other approaches to solve the problem.

Please share your thoughts.

Any guidance or step-by-step solution would be greatly appreciated!

Thanks!