How to Export Data into Microsoft Power BI
Being signed in to your monday account, open Power BI Connector widget, and then copy the link of the required data source.
Launch your Microsoft Power BI Desktop, select Get data, and then select OData.
In the URL field, paste the link of your data source, and then select OK.
Select the Basic authentication.
Left the User name field blank.
For the Password field, you’ll need the access token. Please proceed to step 6 to get it.
Go back to your monday account, and then open Power BI Connector widget.
Select Access Token, and then copy the token.
Go back to Microsoft Power BI, and then paste the copied token into the Password field.
Select the lowest level to apply the settings.
Select Connect.
Select the tables you need, and then select Load.
If there is a large amount of data to import, it may take some time.
After the data is loaded, you can build graphs and dashboards based on the imported monday.com data