Power Platform Community Forum Thread Details

Hi,

I'm using powerapps dataflows.

I'm trying to make a connection to a web api but there is no option under authentication for 'Basic Authentication'.

Only 'Anonymous' or 'Organizational account' are available.

However, when using power query in power BI or Excel the 'basic auth' is available.

Why isn't it available in powerapps dataflows power query online?

Is there something I can do to make it available?

Thank you.

Regards,

Daniel

Categories:

Power Query

Hi,

Unfortunately basic authentication is not available as an option in CDS Dataflows.
However, As per our understanding, you’re looking to enable user-level authentication for your Web API connection in PowerApps Dataflows.
To work around the limited authentication options in PowerApps Dataflows and use M code from Power BI Desktop, you can follow these steps:
Steps to Use M Code from Power BI Desktop in Power Platform Dataflows:

Prepare M Code in Power BI Desktop:
- In Power BI Desktop, go to the Home tab and select Transform Data to open the Power Query Editor.
- Select Advanced Editor in the Home tab to view your M code.
- Copy all the M code from the Advanced Editor.
Create a New Dataflow in Power Platform:
- Go to Power Platform and navigate to Dataflows.
- Select Create and then choose Dataflow.
- Select Blank Query.
Paste M Code in Dataflow:
- In the Advanced Editor that appears for the Blank Query, paste the M code you copied from Power BI Desktop.
Set Up Data Refresh and Save:
- Complete the setup by specifying data source credentials and setting up a refresh schedule if required.
- Save and load the Dataflow, which allows you to use your Power BI Desktop transformations directly within Power Platform.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/