Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I planed to use Powerbi to generate automatic reports...
I already built some of them (Google Analytics, XLSX,...) one by one without automatic refresh... (on Powerbi desktop)
We want to do it in a more professional way including other data (CRM: Microsoft Dynamics and one "big" Postgresql database : 1,8 GB...)
There is a "classic way"
ETL --> DatawareHouse & datamarts SQL (with a new big Postgresql data base) --> Cubes Analysis Services <--- Powerbi
Questions
a response would be greatly appreciated
Have a nice day
Noliverte
Solved! Go to Solution.
Hi @noliverte
Yes I agree.
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 @noliverte
Yes and No, check this out it might help you
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
Thank you Amine for your answer, the link which is very interesting.
If I sum up with my non-technical words
Dataflows offers an all-in-one solution that is an alternative to the classic "ETL --> DatawareHouse & datamarts SQL --> Cubes Analysis Services".
It is not necessarily easier to implement but the solution is robust and allows to manage the entire chain from the ETL to the publication of automated reports under Powerbi.
There are some limitations, but retrieving and storing data from a postgresql database or social media data or building a star model between several heterogeneous data sources is possible.
Do you agree ?
Bye
Olivier
Hi @noliverte
Yes I agree.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.