Totara Learn Open Discussions

API / Power BI

 
WilsonRaechel
API / Power BI
由 WilsonRaechel 发表于 2024年08月12日 Monday 21:42
 

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


 
永久链接 | 回复
CooperLee
Re: API / Power BI
由 CooperLee 发表于 2024年08月13日 Tuesday 05:30
小组 Totara小组 TXP Site Administrator

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

 
永久链接 | 显示父帖子 | 回复
DyckhoffJohn
Re: API / Power BI
由 DyckhoffJohn 发表于 2024年08月13日 Tuesday 17:05
小组 Totara小组 TXP Site Administrator

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.

  1. Generate a scheduled report and send it to my email account.

  2. Gmail filters and tags the email.

  3. A Power Automate Flow recognises the tag, removes the report attachment, saves it in a OneDrive folder, and deletes the email.

  4. 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.

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