Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I want to use the Lookup activity against my Oracle Onprem database, but the pipeline is just getting status Queued:
What is really strange is that it works to use the preview:
What can this be? Really need help 🙂
Br
Marius
Here is also the json for the whole pipeline:
{
"name": "OracleOnpremTest",
"objectId": "<ObjectId>",
"properties": {
"activities": [
{
"name": "SimpleLookup",
"type": "Lookup",
"dependsOn": [],
"policy": {
"timeout": "0.12:00:00",
"retry": 0,
"retryIntervalInSeconds": 30,
"secureOutput": false,
"secureInput": false
},
"typeProperties": {
"source": {
"type": "OracleSource",
"oracleReaderQuery": "SELECT DATE_KEY FROM SCHEMA.TABLE WHERE DATE_KEY = 20240716",
"partitionOption": "None",
"queryTimeout": "02:00:00"
},
"firstRowOnly": false,
"datasetSettings": {
"annotations": [],
"type": "OracleTable",
"schema": [],
"externalReferences": {
"connection": "<connectionid>"
}
}
}
}
],
"lastModifiedByObjectId": "<ObjectId>",
"lastPublishTime": "2024-07-16T10:07:02Z"
}
}
Hi team,
I still have issues with this, even after the onprem is in GA:
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-september-2024-release/
Please, does anyone got oracle onprem to work? Let me know
Friendly reminder @Anonymous 🙂
Hi @mariussve1 ,
A couple of points I wanted to confirm with you: is this the first time you've run this activity, and has there been a similar situation before?
Best Regards,
Adamk Kong
Hi @Anonymous,
I have not been able to use oracle as source or destination in copy activity. Its not working on lookup either. Been like this since day one. But the preview data has worked all the time on both activity.
Does Anyone Get oracle to work in pipeline?
It does work from dataflows, but i need it to work from pipelines as well
br
Marius
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.