Power BI Desktop - Connect to UserVoice

Question

Hi,I am trying to connect to our company's UserVoice account with Power BI Desktop. &nbsp;There is an integration for the online version, but I can't do the calculations I want in that version. &nbsp;Do you know if there is a way to connect&nbsp;by using the&nbsp;UserVoice API that is available for the account? &nbsp;Or a way to connect the desktop application to the UserVoice data in the online Power BI service?&nbsp;Thanks,Tania

v-qiuyu-msft · Answer

Hi taniagobeil,
&nbsp;
Based on my research, you can consider use web data source in desktop to get data from the UserVoice. See: How to call REST APIs and parse JSON with Power BI.
&nbsp;
Best Regards,Qiuyun Yu

taniagobeil · Answer

Hi&nbsp;v-qiuyu-msft&nbsp;I followed the steps in your link and it works like a charm. &nbsp;However, it only works for unauthenticated requests. &nbsp;I want to access User statisfaction responses (/api/v1/reports/user_satisfaction_responses.json) and that requires oAuth authentication. &nbsp;Do you know if there is a way to do this in PowerBI?&nbsp;Thanks for the help!Tania

v-qiuyu-msft · Answer

Hi taniagobeil,
&nbsp;
I think you need to know how to call UserVoice use oAuth authentication firstly. See: UserVoice OAuth Reference.
&nbsp;
Best Regards,Qiuyun Yu

taniagobeil · Answer

Indeed­. &nbsp;I've been looking all over for examples on how to use the UserVoice API.&nbsp;I found this great post from Steve Howard on API Strategies with Power BI (http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/). &nbsp;There is an example on connecting Power BI to the Twitter API using OAuth. &nbsp;I followed the steps and I managed to get the Twitter data easily.&nbsp;I modified the example script to work with User Voice but I always get an error message "The user was not authorized". &nbsp;I am using anonymous authentication. &nbsp;I feel like I am 2 inches away from the solution, but I just can't seem to get it working!&nbsp;Here is the script I am using:// Source: http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/let// Concatenates the Consumer Key &amp; Consumer Secret and converts to base64authKey = "Basic " &amp; Binary.ToText(Text.ToBinary(#"UserVoice API Key" &amp; ":" &amp; #"UserVoice API Secret"),0),url = "https://MYSUBDOMAINHERE.uservoice.com/oauth/request_token",// Uses the oauth2/token method to obtain a bearer tokenGetJson = Web.Contents(url,[Headers = [#"Authorization"=authKey,#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],Content = Text.ToBinary("grant_type=client_credentials")]),FormatAsJson = Json.Document(GetJson),// Gets token from the Json responseAccessToken = FormatAsJson[access_token],AccessTokenHeader = "bearer " &amp; AccessToken,// Uses the method using the bearer token from the previous POST oauth2/token methodGetJsonQuery = Web.Contents("https://MYSUBDOMAINHERE.uservoice.com/api/v1/reports/user_satisfaction_responses.json",[Headers = [#"Authorization"=AccessTokenHeader]]),FormatAsJsonQuery = Json.Document(GetJsonQuery)in#"FormatAsJsonQuery"&nbsp;Any ideas?

anonymous · Answer

Hi&nbsp;@taniagobeil,&nbsp;Did you ever get this working? I am trying to connect our UserVoice account to Power BI and am having similar issues. Unfortunately the UserVoice Data Connector within the data sources list does not work with custom domains using oAuth. Any ideas?

Forum Discussion

Power BI Desktop - Connect to UserVoice

6 Replies

Related content

Power BI Modeling MCP with OpenAI Codex Desktop: connection to Power BI Desktop and Service

Power BI Desktop Oracle Connection Error ORS-50122

Power BI DeskTop Connecting to Excel

Connect Claude Code to Power BI Desktop

Connecting Power BI desktop to Microsoft CLI for reporting