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

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

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

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

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