Yes, you'll need to declare cursor and variables and call it in the query, it has a bit more work around, when SQL server, exec works well. I'd try oledb connection too and call
hi! thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
Hi there, you're welcome. If you are not using parameters, your SQL code should be in double quotes and the format of date should be according to what it is in the database and possibly use functions to convert. If you use parameters meaning going out of doubles quotes, etc, you'll need M functions to convert dates.. I hope I can make a video to cover different scenarios..
Hi there, yeah I see, try installing oracle client for Microsoft tools, ideally use their installer to for the configuration, esp for ODP.net. good luck
Hello, depending on which part you get error, first you need to make sure the oracle client is installed, check for 32 and 64 in odbc drivers. Then build the proper connection string and use a select * from to get into the database as explained in the video
Hello! Thanks for your video! I have an issue trying to connect PowerBI with Oracle Data base.... And is not related to 'Oracle .DataAccess.Client'. I'm doing the connection but when I put all the information in server also query, it bring this error: Details: "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified" Could you give me some advice please? Thanks a lot!
Hello, I'd first make sure the the string is all correct. Also DB admins might change the host names, you'll need to make sure the tnsnames.ora are up to date, hope this helps
Hi there, to pass result of another query or a parameter in the query, you can use Text.combine in M. If result of other query, in needs to be converted to text. However it's a larger subject, I hope I can make a tutorial on this :)
It looks to me your issue is about gateway passing the data, the server machine that the the gateway is installed should have the oadc driver installed as well.
I see, script without parameter is only to put entirely in double quotes. However when there are parameters, you'll need to get out of doubles quotes, come back etc and use different M functions like text.combine. I might do a video on this subject with different scenarios...
Hello, for that you'll need to first install on premises data gateway on your machines, then do the configuration on the online power bi services to link that gateway to your space, then connect your report to that defined gateway and after that schedule your data refreshings
I created a dataflow to get data from local oracle with the gateway, it is working well in loading preview of power query online, but it keeps fail while refreshing the dataflow, and empty error information returned. Really strange, any idea on this ? Thanks a lot
Thank you! I was struggling to get the Oracle data connection set up and your video was extremely helpful.
Oh great, glad it was helpful :)
Thank you very much. Helped me a lot, since I was getting the error becore
You're welcome, happy to hear that :)
how to call oracle procedure in power bi
Yes, you'll need to declare cursor and variables and call it in the query, it has a bit more work around, when SQL server, exec works well. I'd try oledb connection too and call
Thank you very much, I was stuck with a TNS Listener error and this video helped me fix it.
Ah great. You're welcome :)
hi! thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
Hi there, you're welcome. If you are not using parameters, your SQL code should be in double quotes and the format of date should be according to what it is in the database and possibly use functions to convert. If you use parameters meaning going out of doubles quotes, etc, you'll need M functions to convert dates.. I hope I can make a video to cover different scenarios..
Hi, I have been provided a wallet to connect oracle ADB to powerbi desktop, but unable to connect it. can u please help ?
Hi there, yeah I see, try installing oracle client for Microsoft tools, ideally use their installer to for the configuration, esp for ODP.net. good luck
Thank you, this is very helpfull!
Glad it was helpful!
how you rectify that error please explain
Hello, depending on which part you get error, first you need to make sure the oracle client is installed, check for 32 and 64 in odbc drivers. Then build the proper connection string and use a select * from to get into the database as explained in the video
Hello!
Thanks for your video!
I have an issue trying to connect PowerBI with Oracle Data base.... And is not related to 'Oracle .DataAccess.Client'.
I'm doing the connection but when I put all the information in server also query, it bring this error: Details: "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified"
Could you give me some advice please?
Thanks a lot!
Hello, I'd first make sure the the string is all correct. Also DB admins might change the host names, you'll need to make sure the tnsnames.ora are up to date, hope this helps
Hi
Please confirm how to pass the dynamic query at the run time
Hi there, to pass result of another query or a parameter in the query, you can use Text.combine in M. If result of other query, in needs to be converted to text. However it's a larger subject, I hope I can make a tutorial on this :)
it is showing 'No ODAC driver is found on the system'
Are you able to resolve this.i am stuck as well
@@adilumr6359 No
It looks to me your issue is about gateway passing the data, the server machine that the the gateway is installed should have the oadc driver installed as well.
@@BILand can you explain?
did you use the host:port/instance pattern?
I'm trying to load an Oracle SQL script of 800 lines with many parameters into Power BI
I see, script without parameter is only to put entirely in double quotes. However when there are parameters, you'll need to get out of doubles quotes, come back etc and use different M functions like text.combine. I might do a video on this subject with different scenarios...
Hello, how can i connect my oracle db into power bi online service to create a gateway and schedule my atualizations?
Hello, for that you'll need to first install on premises data gateway on your machines, then do the configuration on the online power bi services to link that gateway to your space, then connect your report to that defined gateway and after that schedule your data refreshings
I created a dataflow to get data from local oracle with the gateway, it is working well in loading preview of power query online, but it keeps fail while refreshing the dataflow, and empty error information returned. Really strange, any idea on this ? Thanks a lot