Messages API >> PowerBI? Anyone done it?

Discussion in 'LiquidFiles General' started by Sam-72891, Apr 2, 2021.

  1. Sam-72891

    Sam-72891 New Member

    Oct 18, 2016
    Likes Received:
    Curious if anyone has done this so I don't have to re-invent the wheel.

    Currently I make a monthly report of data that flows through our LiquidFiles server by exporting a CSV from Admin>Data>Messages. I then create a report that shows how many GBs of data and how many messages were received by our Filedrop (we only use 1).

    I'd like to automate this. And I likely have 2 options.
    1). A scheduled script on a local server/workstation that pulls the data from the /messages/sent API, and feeds it into an Excel file for processing/reporting.
    2). But even better would be to have PowerBI link directly to the API and pull in the data. Then I could schedule it for daily updates (even hourly?). The process could be fully automated, and the data would be more 'real-time'-ish.

    It would be great experience for me as I'm trying to learn more about PowerBI. But I'm still pretty new to it. If I figure it out, I'll be sure to post back here with tips!

Share This Page