cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IvanDD
New Member

Gateway From Oracle and one Drive

Dear sirs.

I've created a date set with a connection to Oracle DB e some xlsx in my One Drive.

Now I'l like to configure the gateway, I never did it before.

I installed a on-premises data gateway and connect with my account.

Then I create e connection with a DB Oracle.

The problems are on Excel in One Drive, I have no Idea how to connect them.

I read it's not necessary a gateway, but it asks me to add a gateway

I have also a warning abuot a persona gatewy

Any suggestion?

Thanks

Immagine.jpg

2 ACCEPTED SOLUTIONS
arvindsingh802
Super User
Super User

Please update your excel files in onedrive as Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs, they you will not be needing gateway connection for those


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

GilbertQ
Super User
Super User

Hi @IvanDD 


The error you sent through is certainly an issue from Oracle which I would suggest troubleshooting!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

7 REPLIES 7
GilbertQ
Super User
Super User

Hi @IvanDD 


The error you sent through is certainly an issue from Oracle which I would suggest troubleshooting!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

IvanDD
New Member

@arvindsingh802 thanks, now I'm starting to move the file. There is a way to do it directly or I have to delete the table and make a new conncection?

No need to deleted the table, you only have to update the source connection to point to Onedrive rather than local file

Also as mentioned by @GilbertQ  you can create a datasource and type of source would be file File not web

Also you need to put the files in same directory at gateway server


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

thanks, Now my source conncetion point to One Drive, but I dont if it works cause now I have this problem:

Last refresh failed: Tue Mar 29 2022 14:39:57 GMT+0200 (Ora legale dell’Europa centrale)

Unable to connect to the data source undefined.Hide details

Underlying error code:  -2147467259

Underlying error message:         ORA-01843: not a valid month

DM_ErrorDetailNameCode_UnderlyingHResult:              -2147467259

Microsoft.Data.Mashup.ValueError.DataSourceKind:     Oracle

Microsoft.Data.Mashup.ValueError.DataSourcePath:     ebs_produzione

Microsoft.Data.Mashup.ValueError.ErrorCode: 1843

Microsoft.Data.Mashup.ValueError.Reason:      DataSource.Error

Cluster URI:       WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net

Activity ID:         af1b70d5-d39d-4d27-8313-37c37b2b3681

Request ID:        ff48e445-9521-447a-90e8-bcc2c7bc5b37

Time:    2022-03-29 12:39:57Z

 

It seems a DB oracle trouble. Instead with Power BI desktop it works fine

GilbertQ
Super User
Super User

Hi @IvanDD 

 

If you want to keep the files where they are, you would need to add in the new folder location on your server where the files are stored, which should also be on the gateway server?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ  how can i do that? I tried in gateway as conncet like file and web but it doesn't work

arvindsingh802
Super User
Super User

Please update your excel files in onedrive as Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs, they you will not be needing gateway connection for those


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors