Create Power BI Dataflow using a Semantic Model

[adi38612]

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!

[James_J78]

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 · Accepted solution]

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) 

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

[klev28]

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.

[klev28]

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]

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.