Multiple Tables from AnalysisServices.Databases

[BeaBF]

Hi! I need your help!

I would like to import all the tables contained in an Analysis Services database and automatically send them to Append.

This is the string I use to import a single table in Power Query:

(URL as any, COUNTRY as any) => let

Source = AnalysisServices.Databases(URL, [TypedMeasureColumns=true, Implementation="2.0"])

where URL is a parameter containing the following pointing:

"powerbi://api.powerbi.com/...." meta [IsParameterQuery = true, IsParameterQueryRequired = false, Type = type any]

Is it possible to do what I ask? how?

Thx you,

BF

[Anonymous]

Hi @BeaBF ,

Please kindly check this post whether it helps:

Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot ...

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.