Skip to main content
Solved

Pulling data from Power BI into Gainsight NXT

Ester.Memoli
Forum|alt.badge.img+8

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. 

 

View original
Did you find this topic helpful?

11 replies

cjacksonfe
Forum|alt.badge.img
  • cjacksonfe
  • Helper ⭐️
  • 17 replies
  • Answer
  • 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. 

 

sai_ram
Ester.Memoli
2 people like this
  • sai_ram
    sai_ram
  • Ester.Memoli
    Ester.Memoli
Ester.Memoli
Forum|alt.badge.img+8
  • Ester.Memoli
  • Author
  • Helper ⭐️
  • 87 replies
  • 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
Forum|alt.badge.img+4
  • jean.nairon
  • Expert ⭐️
  • 421 replies
  • 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
sai_ram
Ester.Memoli
2 people like this
  • sai_ram
    sai_ram
  • Ester.Memoli
    Ester.Memoli
Ester.Memoli
Forum|alt.badge.img+8
  • Ester.Memoli
  • Author
  • Helper ⭐️
  • 87 replies
  • July 30, 2021

Thank you @jean.nairon 

jean.nairon
sai_ram
2 people like this
  • jean.nairon
    jean.nairon
  • sai_ram
    sai_ram
spencer_engel
Forum|alt.badge.img+4
  • spencer_engel
  • Expert ⭐️
  • 669 replies
  • 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).

J
  • jivanova
  • Contributor ⭐️⭐️⭐️⭐️
  • 44 replies
  • 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!

 

spencer_engel
H
2 people like this
  • spencer_engel
    spencer_engel
  • H
    Harika Singadi
H
Forum|alt.badge.img+4
  • Harika Singadi
  • Helper ⭐️⭐️
  • 33 replies
  • 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 ?

 

J
  • jivanova
  • Contributor ⭐️⭐️⭐️⭐️
  • 44 replies
  • 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. 

 

H
1 person likes this
  • H
    Harika Singadi
H
Forum|alt.badge.img+4
  • Harika Singadi
  • Helper ⭐️⭐️
  • 33 replies
  • 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
Forum|alt.badge.img+4
  • spencer_engel
  • Expert ⭐️
  • 669 replies
  • 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?

H
Forum|alt.badge.img+4
  • Harika Singadi
  • Helper ⭐️⭐️
  • 33 replies
  • November 23, 2021

Yes,@spencer_engel 

step1:publish the report to power BI .Publishing the report makes the report available in power bI service console

step2: In Power BI service console 

  • Open a report 
  • On the File menu, select Embed report > Website or portal.

For more details, please  refer the below link:

Embed a report in a secure portal or website - Power BI | Microsoft Docs

N
1 person likes this
  • N
    Nashville Williams

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings