This blog help to load data into sql table then process AAS cube using power shell . Later we have execute the sub pipeline below :-
Author: admin
Azure data factory Full Load pipeline Extraction zone
Azure data factory Full Load pipeline There are main pipeline which start the ADF machine as we have integration runtime to connect Oracle database . We have use execute pipeline to load all dim and fact .first part to load only small dim table :-
Write Back using power ON custom Visual at power BI
Power BI visual used custom visual given by POWERON company .Power On given many visual mention below and there custom visual which have smart features which help to visual planned like Table editor ,Smart filter etc. We are majorly discussing on table editor which give functionally to write back feature and update the visual in […]
Restart the Azure ADF machine
We need to stop the azure VM because azure cast each running cast based on used .hence we created powershell scripts to start to stop the Vms based on running . We can use above scripts and please create credential using SPN on azure active directly else its will ask each time to auththe resource
Azure Analysis Cube verification
This power Shell scripts gives each table processing date on mail . This power Shell Scripts will fetch the data from Azure analysis services and send email to email id with each cube table process date like below :-