WriteBack Data from Power BI to Google drive Excel File through Power Automate
Write Back Data from Power BI to Google drive Excel File through Power Automate Prerequisites : 1. The column data types in Power BI and the Excel file on Google Drive must match. 2. Please ensure that you are logged into the connections used in the Power Automate flow. 3. It is mandatory to create metadata in the Excel file on Google Drive. Steps to create Power Automate flow : Step 1: In Power BI Desktop, click on Power Automate. For reference, please see the screenshot below. Step 2: Once the Power Automate visual is opened in the screenshot above, click on the eclipse and select 'Edit. For reference, please see the screenshot below Step 3: After clicking on Edit, you will be redirected to Power Automate. For reference, please see the screenshot below. Step 4: Click on New Flow and select Instant Cloud Flow. For...