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
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
Solved! Go to Solution.
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
Hi @Anonymous
The error you sent through is certainly an issue from Oracle which I would suggest troubleshooting!
Hi @Anonymous
The error you sent through is certainly an issue from Oracle which I would suggest troubleshooting!
@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
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
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?
@GilbertQ how can i do that? I tried in gateway as conncet like file and web but it doesn't work
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
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.