Totara Learn Open Discussions

API / Power BI

هذا المنتدى لديه حد لعدد من الاشتراكات التي يمكنك ان تنشرها في فترة زمنية معينة -هذا محدد حاليا على 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.

الرابط الثابت | اعرض الاصل | رد