Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
adi38612
Frequent Visitor

Create Power BI Dataflow using a Semantic Model

Is it possible to create a Power BI Dataflow using a Power BI Semantic Model?

I have a Power BI Semantic Model being shared with me by the user/creator of the dataset. Now I want to use one table in the model in a Power BI Desktop report. I know it can be imported, but I need this table to be transformed in Power Query before I can use it. As I am unable to import the semantic Model in Power Query, I was wondering if I could create a dataflow referencing this semantic model, and then use that dataflow in my report.

Please share your valuable thoughts on this. Overall, I want an automated way of getting the data from the semantic model, rather than manually copying the data, creating a excel and then again to upload it in the report. This will need frequent refreshes, as the data gets updated quickly, and this is too manual to my liking.

 

TIA!

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @adi38612 

The answer is No, You can't create a Dataflow from a Semantic model. You can use Direct Query connection to AAS(Or Power BI service) 

aj1973_0-1707953829353.png

 

and then you pick your Table. But you want be able to edit the Table in power query.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

5 REPLIES 5
James_J78
New Member

This is late, but ou can use the Analysis Services Database connector in power query within Power bi desktop

and use the semantic models server connection string. Then you can transform the data from the other semantic model. However this method is an import mode though, but leverages native query and will only I port the data you actual query within the model. 

aj1973
Community Champion
Community Champion

Hi @adi38612 

The answer is No, You can't create a Dataflow from a Semantic model. You can use Direct Query connection to AAS(Or Power BI service) 

aj1973_0-1707953829353.png

 

and then you pick your Table. But you want be able to edit the Table in power query.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hi, I have the same query. I want to use the existing model but only need a higher aggregate and not all fields. What is the best way to connect and aggregate the data? Now I've ruled out the dataflow option I'm planning to direct query the model then use dax to summarise it, maybe "hiding" the original tables in the model? Is there anything I need to know before trying this? thanks for any advice. I found it hard to find any guildelines on this type of data requirement online.

Actually, another thought. Perhaps I don't need to aggregate it in my model. As it's a direct query is it just as good for me to just aggregate it in my report visuals. I'm not actually brining the raw data into my report right? Will powerbi do the work for me to keep my report efficient?

 

Coming from a SQL background I do have a tendency to overthink a PBI solution or not realise that a solution is actually super simple!

aj1973
Community Champion
Community Champion

Hi @klev28 

If you are using DQ mode connection then you can't aggregate or use Summarize in your model.

Since your background is SQL then better create a view directly in the source and connect Power BI in DQ mode.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.