Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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
Community Champion
Community Champion

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 @Anonymous 


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 @Anonymous 


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

Anonymous
Not applicable

@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!!
Anonymous
Not applicable

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 @Anonymous 

 

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

Anonymous
Not applicable

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

arvindsingh802
Community Champion
Community Champion

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors