Go to Options > Output Options. Check if Create is the default option. Choose the Workspace you want to work with and select New Dataset. To create a new dataset in Power BI, go to the configuration window, then Data tab.

The following steps show you how to work with datasets: Contact your administrator to request the secret which is a Secret Value, not Secret ID. Power BI Output requires Client Secret even when connecting with Client ID and Secret, Tenant ID without using as service principal. This is convenient, for example, if a user leaves the company and their account is disabled, causing workflows to not run. However, if you select Use as service principal after you select Provide authentication information, you can set the expiration of the token according to your company policy and the scheduled workflows won’t be associated to a single user. You can use the default Alteryx application ( Sign in via Internet Browser) to schedule workflows for up to 6 months. See the Custom API Application Setup section for the information on how to create your own API application. The OAuth method is used for authentication, so you can either use the default Alteryx application via Sign in via Internet Browser or you can provide your own API application via Provide authentication information.

Convert the DateTime values to strings before uploading the dataset to Power BI. See Microsoft's Push datasets limitations for limitations and additional details.ĭue to Power BI API limitation, Designer can't write DateTime values. To use this tool, download it from the Alteryx Community. This tool is not automatically installed with Designer.

Microsoft power tools download