I am looking for a way to make API Calls in Power BI through buttons or Power Automate which would call that specific data from database, but I can’t connect my dashboard to the database directly I have to make an GET request via API that will send back the desired data to Power BI and then onto an already created dashboard with basic schema as it’s base(i.e. saved in .pbit format link to data as per viewers request then show it). The database already has RLS implemented so users can view only the data available to them, and API returns data in json form

P.S. –> The database is not on any Microsoft platform, and not very experienced with Power BI as well😓

How should I go about it ??

I was looking into options for this and found either I use Power Automate or JavaScript or Python that does API Calling but didn’t went too far