Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Er have a AR report and our invoice distributor had an api that can return a pdf copy of an invoice. It is a POST api, but if we include customer number and invoice number, it returns a pdf. I have had it work with python.
I was thinking of integrating this in the report.
How could the user for example click on an invoice number, or enter the invoice number somewhere and trigger a request to get the invoice...
Or should I integrate a power app in the power bi?
Solved! Go to Solution.
I ended up doing it with power automate. I pass on customer and invoice number to the power automate visual. When it is triggered, it uses the HTTP connector to send a API request. It returns the pdf, that is then saved to a sharepoint library, and then finally email it to the requestor.
Yes, PowerApp or Python visual is pretty much your only choice if you want to keep the user inside the report.
I ended up doing it with power automate. I pass on customer and invoice number to the power automate visual. When it is triggered, it uses the HTTP connector to send a API request. It returns the pdf, that is then saved to a sharepoint library, and then finally email it to the requestor.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
2 | |
1 | |
1 | |
1 |