Alteryx source - Power Query

Hi community,

I need to connect my Alteryx to a Query I have in a Power Query Excel file. The information is so extended, I need to connect Power Query to the data base and not download it in the Excel file, so I leave the information only with the Query connection.

So, then I need to get that information, connecting Alteryx to that query but I am not finding the way to do it. What I see is that Alteryx only let me connect to the sheets of the Excel file and not to the querys.

What I need to do is possible? I was able to do this with Power BI.

Thanks in advance.

Florencia

Developer

Input

Best Practices

Join

Database Connection

Accepted answers

patrick_mcauliffe

@florebrunialtiCube data is calculated by the cube's server at the time of query. It doesn't sit in a format that can be queried.

Check this out though:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SSAS-Cube-Connection-and-MS-Power-Query/m-p/13405#M6584

All comments

patrick_mcauliffe

@florebrunialtiWhat is the source that the Power Query is pulling from?

florebrunialti

It is a company local data base cube I couldn´t connect directly to Alteryx, so I tried to connect the cube to Power Query and then connect that query to Alteryx.

rishabhjain_bofa

patrick_mcauliffe

What if the data source is a WEB PORTAL from where we pull reports? The reports , when pulled manually, are extracted in an excel file.

patrick_mcauliffe

@rishabhjain_bofaif you're pulling reports from a web portal that get exported from the web app as an Excel file, then your best option is to find out where the web app gets its data from.

While it is possible to use some web portals as data sources, it can get very messy and complex quickly.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703