Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

power bi report server + dynamics 365 on-premise + refresh data

have anyone succesfully make these two work together.   what i have achieved now is:   i can successfully connect powerbi desktop to dynamics 365 on-premise, and develop reports. (oauth enabled) ...
help needed
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    thanks Greg.

     

    but I ended up with writing a data gateway myself to automate an ADFS authentication process  (WS-Federation protocol), then act as a reverse proxy to the ODATA api.

     

    Golang rocks btw...

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Connect to your SQL database?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks Greg.

     

    but I ended up with writing a data gateway myself to automate an ADFS authentication process  (WS-Federation protocol), then act as a reverse proxy to the ODATA api.

     

    Golang rocks btw...

    • walkingstar's avatar
      walkingstar
      Frequent Visitor
      6 years ago

      Could you give any details on how you configured your Data gateway. I have sent a personal msg as well. Can you get back to me ?

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        i hope you like python.

        walkingstar 

        the key here, is to do a trace using chrome/firefox dev console.

        get the idea of the whole authentication process.

        then automate the process using whatever programming language you are familiar with.