Skip to main content
Ester.Memoli
Ester.Memoli
Helper ⭐️
Jul 26, 2021 8:09 AM UTC
Solved

Pulling data from Power BI into Gainsight NXT

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

cjacksonfe
cjacksonfeAnswer
Helper ⭐️
Jul 27, 2021 4:12 PM UTC

@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. 

 

View in thread

11 replies

cjacksonfe
cjacksonfeAnswer
Helper ⭐️
Jul 27, 2021 4:12 PM UTC

@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. 

 

Translate
    Ester.Memoli
    Ester.MemoliAuthor
    Helper ⭐️
    Jul 29, 2021 2:29 PM UTC

    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 :)

    Translate
    jean.nairon
    jean.nairon
    Expert ⭐️
    Jul 29, 2021 3:46 PM UTC

    @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

    Translate
    Jean
      Ester.Memoli
      Ester.MemoliAuthor
      Helper ⭐️
      Jul 30, 2021 7:58 AM UTC

      Thank you @jean.nairon 

      Translate
        spencer_engel
        spencer_engel
        Expert ⭐️
        Oct 20, 2021 3:50 PM UTC

        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).

        Translate
        jivanova
        Contributor ⭐️⭐️⭐️⭐️
        Oct 21, 2021 12:51 AM UTC

        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!

         

        Translate
          Harika Singadi
          Helper ⭐️⭐️
          Nov 12, 2021 12:01 AM UTC

          @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 ?

           

          Translate
          jivanova
          Contributor ⭐️⭐️⭐️⭐️
          Nov 12, 2021 1:43 PM UTC

          @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. 

           

          Translate
            Harika Singadi
            Helper ⭐️⭐️
            Nov 12, 2021 3:24 PM UTC

            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.

            Translate
            spencer_engel
            spencer_engel
            Expert ⭐️
            Nov 23, 2021 7:46 PM UTC

            @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?

            Translate
            Show more replies
            Terms & ConditionsAccessibility statement