Totara Learn Open Discussions

API / Power BI

 
Raechel Wilson
API / Power BI
by Raechel Wilson - Monday, 12 August 2024, 9:42 PM
 

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


 
Permalink | Reply
Lee Cooper
Re: API / Power BI
by Lee Cooper - Tuesday, 13 August 2024, 5:30 AM
Group TotaraGroup 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

 
Permalink | Show parent | Reply
John Dyckhoff
Re: API / Power BI
by John Dyckhoff - Tuesday, 13 August 2024, 5:05 PM
Group TotaraGroup 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.

 
Permalink | Show parent | Reply