*Dear Experts
I need to setup a power bi configuration for generating dashboard report on power bi services in environment similar to (azure sql server) , please review the attached Image with the thread , I need to do this setup on the cloud using (open source) repositories (Not Azure).
The Infrastructure and processes as the following:
-
Extract the data from API as (JSON) format.
-
Create a script e.g.(Python) that convert the JSON format into Tabular (Row & column) format the script will do the cleansing part of the data.
-
The script on (2) will Insert/Update the data into (Mysql or Postgressql) DB.
-
We need to put the Power Bi (PBi) desktop application in a server (cloud).
-
This server on (4) have credentials on (PBi) services to refresh the data daily and setup this through Enterprize Gateway.
-
The User will be able to read the updated data from (PBi) cloud services.
I need the Ideal setup to do the above Infrastructure as an alternative of (Azure Sql server) , taking into consideration the following:
- The host(s) should be in the cloud.
- For The power bi desktop application (4) is it better to be on the same host of the DB (3) or in a separated host? which is more better? explain please.
- The alternative solution should be less cost than Azure by at least 40-50%.
Waiting your advises.
