Scheduled refresh not working because of error "Unable to combine data"

[mariopavic]

Hi all,

when I try to refresh my dataset i get an error "Unable to combine data". Everything works on power bi desktop but my scheduled refresh is not working.

Code after I tried https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/:

DuplicatedTable = AllIssueKeys, //fetches the initial list of issue keys
NewColumn = Table.AddColumn(DuplicatedTable, "Issue",each Json.Document(Web.Contents("https://myjira.atlassian.net",
       [RelativePath = "rest/api/3/issue/"&[IssueKey],
       Query=[]])))

Thank you in advance,

Mario 

[v-frfei-msft · Accepted solution]

Hi @mariopavic ,

Please change the privacy level to none and check again.

[mariopavic]

@v-frfei-msft Thanks for the answer, but I still have the same error.

Picture: https://ibb.co/MfdGhNJ

[v-frfei-msft]

Hi @mariopavic ,

As the error message, please check the creditional of the site and re configure the data source for it in your gateway if necessary.

[mariopavic]

thanks for the response again @v-frfei-msft . 

I've checked all credentials for the site and data sources. Also I've put privacy level to combine data according each file's privacy level settings. I've also checked is my api token correct. 

I don't use gateway connection since all my data sources are in cloud.

Is there something else I can check? 

[mariopavic]

Well this is strange. This is working now and what I've done is:

1. Set the privacy level as you said

2. Moved my code to the first data table

3. Changed my reqeust to consume the same API, because I was using two different ones (this fixed it)

I was using jira API 2 and 3 and switched to 2 because I haven't seen API 3 in "Data source settings" in current file. @v-frfei-msft  do you maybe know the reason why API 3 wouldn't show up in "Data sources in current file"?