From API to SSAS connection

[ronaldbalza2023]

Hi everyone, I was wondering how to setup a connection from an API to SSAS and eventually use SSAS as a dataset to power bi? Is there any tutorial recommendation/documentation perhaps on this? Thanks a lot! 🙂

[Anonymous · Accepted solution]

Hi @ronaldbalza2023 

Power BI support SSAS connector. You can connect to SSAS by SSAS connector directly.

Here is the offical blog about how to connect to SSAS in Power BI Desktop.

For reference: Connect to Analysis Services tabular data in Power BI Desktop

If you want to connect to your data source by REST API, you may refer to this blog and try web connector.

Using a REST API as a data source

Best Regards,
Rico Zhou

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