Forum Discussion
General question about Data Flows and automatic reports
Hi
the company I work for wants me to create reports that pull data from SAP and automatically transform and clean it and put it in the form they want.
This data from SAP always keeps the same form and should therefore be automatically transformed into the form I specify.
As I have understood it correctly, I would do this process with Data Flows.
If this is not the case, I would be very happy if you could explain to me how this could be done.
Many thanks to all in advance.
Hi, prenkava
Please check if these tutorials and threads could help.
https://www.youtube.com/watch?v=y3se-VEDvqU
https://community.powerbi.com/t5/Service/SAP-BW-Dataflows/m-p/636441 .
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
Best Regards,
Community Support Team _ Eason
3 Replies
- vanessafvgCommunity Champion
there a variety of ways of doing things it just depends on your requirements and why you are doing it a certain way. You can do this with data flows, or you can just pull directly into Power BI. However the dataflows is more easily resusable.
Here is more information unless you have a specific question.
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
- prenkavaNew Member
Hi
could you please tell me in which other way it would work to? Then I can evaluate which option fits in the best for me.
Btw. are there official video tutorials for data flows, not only the doc?
Thank you!
- v-easonf-msftCommunity Support
Hi, prenkava
Please check if these tutorials and threads could help.
https://www.youtube.com/watch?v=y3se-VEDvqU
https://community.powerbi.com/t5/Service/SAP-BW-Dataflows/m-p/636441 .
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
Best Regards,
Community Support Team _ Eason