Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Michael_Cai

SQL Server Analysis Service connection to Dataflow

Submitted by on ‎10-27-2019 09:39 PM
Support Dataflow connections to SQL Server Analysis Service (SSAS), which desktop data sets allow users to do. At the moment, dataflow does not even support the use of a copied M script from desktop connected to SSAS in a blank query. See forum post below: https://community.powerbi.com/t5/Service/SQL-Server-Analysis-Services-as-a-Dataflow/m-p/828241#M79336
Status: Needs Votes
See more ideas labeled with:
21 Comments (21 New)
Comments
DPMulay
New Member
‎08-12-2021 06:44 AM
Please add this as soon as possible
Marcelo_Conte
New Member
‎11-12-2021 05:52 AM
Please add this feature option for Dataflow's connectors!!
mszetyinszki
New Member
‎05-02-2022 10:58 PM

I've been waiting for this for a long time., Poor attitude from MS. Not all customers have Azure AS,

Jamie_Burgess
New Member
‎07-24-2022 10:18 PM

Please add this feature

Pronab_Das
New Member
‎12-12-2022 10:14 AM

Please provide a native connector for SSAS in the next update.

SELVAKUMAR_RAMA
New Member
‎01-12-2023 04:33 PM

SSAS connector is available in Power BI to create datasets but not in Dataflow so we can't create SSAS datasets via Dataflow.

This looks disappointing as the connectors are not in sync with in Power BI between Power BI report dataset with Dataflow dataset.


Please add this connector.

jrussi
New Member
‎03-10-2023 01:40 PM

Same ideia for Datamarts. Today if you have a complete model in SSAS with 30 tables, you must redo the work in a Datamart.

dbeavon
Advocate I
Advocate I
‎03-22-2023 02:57 PM

It has been four years, but it looks like Microsoft is ready to improve dataflows, and allow us to connect to on-prem SQL SSAS.


Here is the release wave for 2023, with a "public preview" in April:



Use the SQL Server Analysis Services

connector in Power BI dataflows


https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave1/data-integration/sql-server-analysis-services-connector-power-bi-dataflows



Anonymous
Not applicable
‎10-30-2023 09:34 AM

Yes, yes. This is really needed. There is a ton of corporate data living in SQL Analysis Services, even right here within Microsoft. Often there is no way to get to the backend sources, and the SQLAS models have added essential semantic layer constructs / metrics / etc. Really need a connector for this data source.


v-eljo
New Member
‎09-15-2024 02:43 AM

Did this actually happen?? Did support for dataflow accessing On-Prem SSAS get include in a release?