Totara Learn Open Discussions

API / Power BI

这个讨论区有规定周期内发帖数的限制，它被设置为 2天内最多发 3 个帖子。

Hi all

Is anyone pulling data from Totara using an API to use in BI reporting?

If you are, we would love to chat!

Thanks

Raechel

永久链接 | 回复

Hi Raechel

This doesn't strictly answer your question, but there is a customer who sends a scheduled report to an MS Teams channel; each has a unique email address (i.e., Data From Community <73d77dc5.totara.com@au.teams.ms>) and then Power BI picks up the file automatically from there.

It's a clever way to get the file into the Microsoft architecture, where the file can be used for many things

永久链接 | 显示父帖子 | 回复

Hi Raechel,

I use a method similar to Lee's, but as we don't use MS Teams, I take a couple of different steps to make the data available to PowerBI.

Generate a scheduled report and send it to my email account.
Gmail filters and tags the email.
A Power Automate Flow recognises the tag, removes the report attachment, saves it in a OneDrive folder, and deletes the email.
PowerBI's 'scheduled refresh' picks up the new file and refreshes the report. (This step requires a data gateway to be running).

I hope that helps.

永久链接 | 显示父帖子 | 回复

Hi Raechel Hunt,

We are currently planning to use the API for Power BI reporting, but I would be curious to hear about your experience if you’re open to sharing it.

Thank you,
Ilona

永久链接 | 显示父帖子 | 回复

We are currently still using scheduled reports to feed our Power BI data, but intend to put this into our upcoming upgrade to version 20.

永久链接 | 显示父帖子 | 回复