Power Query - Get and Transform connection to Magento Databases Directly

D

daleholden

Board Regular
Joined
Sep 22, 2002
Messages
243
Hello Guys

Has anybody found a way to connect directly to Magento databases to extract data on a read-only connection basis?

I have seen some $600 rip off pieces of software but I am sure there must be a direct connection excel can connect.

I have searched on here and Google with no luck.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

H
  • Question Question
power query - apply transformation/cleaning of one query to the next query.
Replies
2
Views
211
heathball
H
M
  • Question Question
Database Username / Pass for Power Query Connection not saving in Excel workbook
Replies
1
Views
994
ExcelToDAX
E
L
  • Question Question
Excel Power Query Refresh Does Not Update
Replies
2
Views
2K
legalhustler
L
T
  • Solved
Data query connection
Replies
4
Views
696
tcourter
T
C
  • Solved
Help me Convert, Merge and Transpose a pdf table into a singular row, and then repeat that step ad nauseam to create a database
Replies
5
Views
628
Clonk92
C

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top