Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Automating Data Exports in BI

Hey All,

 

I have been looking to automate reporting from the social media platforms (Facebook, Instagram, Youtube, Twitter) but I have run into some issues with their API.

 

My 2nd thought was to create individual folders per platform with data exports in it. I would be doing this weekly. Any Idea of how I would go about this or any other ways that might be better?

 

Thanks!

 

Phil 

Need Help
Tips and Tricks
Tutorial Requests

6 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous 

     

    1) what are the current issues you are expericing?

    2) which api are you referring to?

    3) if you dumped the data one onedrive or sharepoint, i think it would automatically update in the cloud

    4) where are you displaying your data in powerbi.com?

    5) have you consider microsoft flow?

    6) do you have a data gateway set up if you using the cloud?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      vanessafvg

       

      Thanks for the quick response! Answers below

       

      1) what are the current issues you are expericing/Which API? I am reffering to the social API. Facebooks Graph API does not allow for someone to download organic post metrics anymore (post message with impressions, video views etc), you have to use their platform. Twitter I can't seem to crack their API either. YouTube, I have been able to work with since Google generally is easy to work with. Instagram, Their api seems pretty closed ATM. 

      3) if you dumped the data one onedrive or sharepoint, i think it would automatically update in the cloud. Let's say I renamed columns in Power BI from the data I put in, if I continued to dump that data on sharepoint or onedrive would Power BI be able to read it?

      4) where are you displaying your data in powerbi.com? I am creating a dashboard on Desktop, publishing it to my online account, then publishing it to a link.

      5) have you consider microsoft flow? I have not actually.

      6) do you have a data gateway set up if you using the cloud? I have an on premise gateway setup

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Anonymous  how do you propose to get the data from those systems without the API's

         

        instgram i think you have to pay for.

         

        check out flow, to start with to see if it meets your requirements because the other routes you are proposing sounds like a bit of set up and i am not sure  how you would do that outside of the API

         

        https://flow.microsoft.com/en-us/