Skip to main content
Ester.Memoli
Ester.Memoli
Helper ⭐️
July 26, 2021
Solved

Pulling data from Power BI into Gainsight NXT

  • July 26, 2021
  • 11 replies
  • 896 views

Hello,

as far as I know, there’s no connector for Gainsight NXT and Power BI. Is there anything in the roadmap?

Or which would be the best way/workaround to pull data from Power BI into NXT?

 

Thanks

Best answer by cjacksonfe

@Ester.Memoli , it’s my understanding that Power BI is not necessarily a datasource in and of itself, but rather an analytics tool that connects to different sources of data and then you can correlate it and so on. 

Given that assumption, I don’t think there’s a possibility to get the data from BI into something else - you would just figure out what sources are feeding it, and feed those into Gainsight. Mind you, I’m not an expert or anything in the BI space, so I might be short-selling PBI’s capabilities, but that’s the path I would take. 

 

11 replies

cjacksonfe
cjacksonfeAnswer
Helper ⭐️
July 27, 2021

@Ester.Memoli , it’s my understanding that Power BI is not necessarily a datasource in and of itself, but rather an analytics tool that connects to different sources of data and then you can correlate it and so on. 

Given that assumption, I don’t think there’s a possibility to get the data from BI into something else - you would just figure out what sources are feeding it, and feed those into Gainsight. Mind you, I’m not an expert or anything in the BI space, so I might be short-selling PBI’s capabilities, but that’s the path I would take. 

 

    Ester.Memoli
    Ester.MemoliAuthor
    Helper ⭐️
    July 29, 2021

    Hi @cjacksonfe you made a valid point.

    I’m not a PowerBI expert too, so it’s an interesting and useful comment about its purpose and use. 

     

    Thanks :)

    jean.nairon
    jean.nairon
    Expert ⭐️
    July 29, 2021

    @Ester.Memoli - you can load data to PowerBI just like Tableau or any other analytics tool.There’s generally no way to transform data in PBI except for merging tables.

     

    If you load data to PowerBI, you can load the same data to Gainsight via S3. 

    https://support.gainsight.com/Gainsight_NXT/Connectors_(Horizon_Experience)/File-Based_Integration/Gainsight_S3_Connector

    Jean
      Ester.Memoli
      Ester.MemoliAuthor
      Helper ⭐️
      July 30, 2021

      Thank you @jean.nairon 

        spencer_engel
        spencer_engel
        Expert ⭐️
        October 20, 2021

        Has anyone on this thread had success displaying PowerBI data in a Horizon Analytics dashboard? I assume it should work fine (I won’t be able to test myself for another couple weeks in my org).

        jivanova
        Contributor ⭐️⭐️⭐️⭐️
        October 21, 2021

        Hi @spencer_engel , I was able to embed power bi, tableau and other dashboard and reports in C360 and HA, but not able to figure the embedded filters so that only account level info displays when in C360. There is a very poor documentation in how to add parameters and filters, so if anyone has successfully done it, please share!

         

          Harika Singadi
          Helper ⭐️⭐️
          November 12, 2021

          @spencer_engel @jivanova  are you successful in embedding power BI reports into Gainsight dashboard.
          I guess you are using PowerBI embed feature to import it to Gainsight ?

           

          jivanova
          Contributor ⭐️⭐️⭐️⭐️
          November 12, 2021

          @Harika Singadi - we are not successful because GS has a limit of 255 characters for the url to be embedded. Power Bi urls are longer than that even before you append custom filter to display only account level info in C360. Please vote for this item to have GS extend the character limit so we can all make use of embedding. 

           

            Harika Singadi
            Helper ⭐️⭐️
            November 12, 2021

            Thanks @jivanova . I have just voted or the requirement.
            Can you please let me know for any other ways that we can embed the third party reports into Gainsight dashboard.

            spencer_engel
            spencer_engel
            Expert ⭐️
            November 23, 2021

            @Harika Singadi How do I embed a Power BI report into Horizon Analytics? The documentation is poor https://support.gainsight.com/SFDC_Edition/Reports_and_Dashboards/Horizon_Analytics/Admin_Guides/Configure_Dashboards_(Horizon_Analytics)#Configure_Web_Page_Widget

             

            I tried just copying and pasting the URL straight from Power BI, but that didn’t work. Do I need to generate some kind of embed code from Power BI?

            Show more replies
            Terms & ConditionsAccessibility statement