Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to 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.
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 @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.
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!
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
88 | |
46 | |
25 | |
21 | |
19 |