SQL Server Analysis Service connection to Dataflow

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...

Data Factory | Connectors

power bi

dbeavon

Advocate I

3 years ago

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

Recent ideas

Enable Ownership Change / Take‑Over for Mirrored Database Items in Fabric
Mirrored DBs do not support ownership transfer today. This becomes an issue when someone leaves the company. And the user tied to the ownership is beeing disabled. That means you need to recreate the...
Sigurd
New Member
59 minutes ago
New
865Views
25likes
3Comments
Option to hide item counts in filter pane
Allow report authors to hide counts displayed next to filter values while preserving filtering functionality. Currently, Power BI displays record counts next to values in filter panes and certain s...
saul_galdamez
New Member
3 hours ago
New
12Views
0likes
0Comments
Allow Detect Data Changes for Historic Data Outside Incremental Window
In Power BI Incremental Refresh,Detect Data Changes only works inside the incremental refresh window. If historic data gets updated, Power BI cannot detect or refresh it unless I expand the increment...
NAGAKEERTHI_Y
New Member
7 hours ago
New
119Views
1like
1Comment
Enable sorting of diagram pages in Power BI Desktop
I, as a developper, rely a lot on model view and diagrams... It's annoying to not be able to sort the diagram pages in this view, since I tend to try to organize these by subject and it becomes a...
Daproulx
Frequent Visitor
7 hours ago
New
10Views
0likes
0Comments
'Move Data' Pipeline Activity
If files land in a Lakehouse folder (e.g. 'Received') and then need moving to a different folder once they have been loaded (e.g. 'Processed'), currently in a pipeline you need a 'Copy Data' step to ...
OMackenzie
Advocate I
8 hours ago
New
8Views
0likes
0Comments

SQL Server Analysis Service connection to Dataflow

Use the SQL Server Analysis Services

connector in Power BI dataflows

Enable Ownership Change / Take‑Over for Mirrored Database Items in Fabric

Option to hide item counts in filter pane

Allow Detect Data Changes for Historic Data Outside Incremental Window

Enable sorting of diagram pages in Power BI Desktop

'Move Data' Pipeline Activity