One Report Connected to Two Different Sources

[ziyabikram96]

Hi,

I have a report which is connected to an oracle database via Personal Gateway. Moreover, I have an excel file whose data I can import into the existing report's dataset. The problem is that the scheduled refresh of the report via gateway fails due to the excel data present in the dataset. How can I overcome this problem?

Thanks.

[v-diye-msft · Accepted solution]

Hi @ziyabikram96 

Is the oracle database imported into the power bi ? Did you configure the excel's confidential into the gateway?,please make sure you've followed the all steps listed as the official document:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#:~:text=%20Add%2... 

if the error still exits, please kindly provide more details about the error message. 

if you can provide the browser trace, that would be much helpful.

You can find the detailed capture steps here: https://docs.microsoft.com/en-us/azure/azure-portal/capture-browser-trace  

[ziyabikram96]

Scheduled refresh is throwing error because I have added the new datasource into the dataset in PowerBI Desktop but haven't included it in Gateway sources.

[v-diye-msft]

Hi @ziyabikram96 

Please add it into the gateway, and let us know if it works now. 

[Greg_Deckler]

@ziyabikram96 - What is the failure?

[ziyabikram96]

Credentials problem of the excel file. 

This problem occurs when I import local version of the file. The same file is also present in onedrive but, I haven't tried to establish web connection with it. I suppose, the dataset refresh via gateway would still fail even if I import that excel via web connection URL.

I will have to see if it still throws the same error but I guess it would.

[lgordon]

Are you able to put the Excel file into OneDrive or Sharepoint?

See these docs for additional info:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive#what-are-the-adva...

https://docs.microsoft.com/en-us/power-bi/connect-data/service-excel-workbook-files#where-your-workb...