Forum Discussion
Query Power BI Service dataset into Dataflow
I have a dataset model running in the Power BI service. I want to run a DAX query against this dataset to get a table result into a dataflow/datamart.
I have been trying to use the SQL Server connector in the datamart power query and using the connection string provided by the Power BI dataset settings, but it keeps giving an error. (I have been trying different combinations of the string in the Server and Database fields - it says only Server is a required value but it needs a value entered into the Database field to initiate the connection).
I know this dataset is accessible from externally from my location because I can connect to it from Tabular Editor and DAX studio.
Is this possible in Datamart / Data Flow?
If you really must, use the Analysis Services connector with a custom DAX query.
However this is a design red flag. A dataflow should get its data from the original data source, not from a secondary source like a semantic model.
4 Replies
If you really must, use the Analysis Services connector with a custom DAX query.
However this is a design red flag. A dataflow should get its data from the original data source, not from a secondary source like a semantic model.
lbendlin that works - the "Azure Analysis Services" connector succesfully ran.
In my use case, I am more interested in using these data in a Data Mart where I am combining data from our primary dataset (itself built on Data Flows from our original data source) with other ad hoc data required for a specific tailored analysis. All of our measures and dimensions are standardized in this primary Dataset so they are consistent across the org (I assume you would agree with this approach).
In this Data Mart analysis, I just need a specific set of measures filtered/sliced a certain way for this analysis. The other data I am combining with these data from our Dataset does not qualify to be integrated into our Dataset (which is what I would need to do to be able to model against them and visualize in a report). A Data Mart provides a potential solution for this.
Rumor has it that datamarts are on the way out (in favor of the new Fabric offerings). Personally I never liked them as they were just glorified dataflows with an Azure SQL instance slapped on in front. A solution looking for a problem (in my opinon).
Glad you got it working.
