Query: Power BI Custom Visual API Block – GPT/Gemini Integration Issue
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 Built a custom visual in Power BI using React and TypeScript Integrated OpenAI/Gemini API logic inside the visual Created a proxy API server to forward the API requests 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!
How I can sort links in Sankey diagram to clean the chart?
Hi, I am using custom visual that is Sankey Diagram by ChartExpo. Chart is created successfully, but I want to sort the links to make the chart clean. Please guide is there any way or property to sort the incoming and outgoing links? Chart is hsown as below: TIA
PowerBI Custom Visual - Offer Change - Certification Loss
Hey Community, Recently I've been able to create a PowerBI Custom Visual and very recently it has been accepted for a Certification. My question is what changes to the offer am I allowed to make without the need of going for recertification process? I've been thinking about changing and adding a few screenshots to the offer, perhaps a small change of description - If i make those changes will I need to go through the whole process and waiting time again? If not, which options should I avoid or click while editing the offer to not have to certificate again and keep the current certification. Thanks
How to filter all visuals in a Power BI custom visual without specifying a table name?
I have a custom visual in Power BI, and I've written the following code to filter other tables based on a column called DateID: public update(options: VisualUpdateOptions) { const filter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "MRS3 vwMrsFactSales", column: "DateID", }, operator: "In", values: [13991002, 13991006], }; this.host.applyJsonFilter( filter, "general", "filter", powerbi.FilterAction.merge ); } it works when i specify table name in target but what i want is to filter all tables in report and i dont know waht are table names and when i remove table from target it broke. what should i do? I searched a lot, but there is no good documentation or YouTube video about this.
Refreshing Data from Power BI Custom Visual Source Code
Hello, I currently have a use case where I need to refresh the Power BI Report Dataset through my Power BI Custom Visual source code on certain events. I know it is possible to refresh the dataset using host.refreshHostData(). However, this is a restricted API and it looks like it is necessary to upload the visual on AppSource for the API to work well. Unfortunately, we do not plan to upload our visual on AppSource. Is it possible to get access to the refreshHostData API without uploading it on AppSource? If not, then are there any other alternatives like LogicApps or Power Automate using a trigger event sent through the custom visual?
