Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error using AMP engine | Power BI Output

edwin_lee_2025
6 - Meteoroid

Hello.

 

I am trying to connect Alteryx with Power BI with the tool "Power BI Output", but when I run the pipeline I get the errors:

Requerid fields cannot be empty

Error using AMP engine

 

Although, I am filling all blanks that Alteryx asks me to fill.

 

I upload an image with more detail.

 

Hope you can help me, please.

 

Thank you.

 

Edwin Lee

10 REPLIES 10
OTrieger
13 - Pulsar

@edwin_lee_2025 , @frank58richard 

Have you tried to untick the AMP Engine? Click on Canvas, Go to Runtime, scroll down and untick Use AMP Engine.

abacon
10 - Fireball

The Power BI tool might require AMP engine to be enabled. This might not be an error with AMP engine, it might be something funky with the configs or a field you are passing through is getting cleared for some reason. Can you post the workflow to this thread?

edwin_lee_2025
6 - Meteoroid

Thank you for your comments.

 

I unticked AMP option and runned the workflow.

 

I upload the message I got after runned the workflow.

 

Wait for your reply, thank you again.

 

Edwin.

 

 

 

edwin_lee_2025
6 - Meteoroid

Thank you for your comments.

 

Here is the workflow...

 

Wait for your reply, thank you again.

 

Edwin

abacon
10 - Fireball

Could you upload the entire workflow or a screenshot of the Power BI tool configs? Sorry for the confusion. 

edwin_lee_2025
6 - Meteoroid

Thank again for your reply.

 

Could you please give me more detail about the configs you want to see?

 

Regards.

 

Edwin

abacon
10 - Fireball

The settings for the Power BI tool. I am wondering if a field is missing in the configurations of the Power BI tool that is throwing that error. The Power BI tool requires AMP engine to be enabled so I am thinking the error has to be around the configurations. I haven't used that tool specifically but I have used the Tableau output tool extensively, they appear to have similar interfaces.

Ivan_F
6 - Meteoroid

Hello,

I talked to Microsoft Power BI developers from my company about the errors you're seeing with the Alteryx and Power BI. Most of the time, these errors come from setting things up wrong or using data that doesn’t match. Here are some quick tips to help you fix it:

  • Make sure all the needed fields are filled out. This includes the Dataset Name and Table Name. The dataset name should be unique, and the table name needs to work with Power BI. Also, check that you've picked a valid Workspace and logged in to Power BI correctly.
  • If your data has DateTime values, you’ll need to change them to strings before uploading. Power BI can’t handle DateTime fields directly. Use the Formula Tool in Alteryx to do this conversion.
  • Confirm that your login info is correct. If you’re using Client ID and Secret, your Power BI account needs the right permissions to upload data. Check for mistakes in your input if you’re using client credentials.
  • Power BI limits the size of datasets (like 2GB) and how often you can make API calls (like 1 per second). If you're trying to upload a big dataset, think about breaking it up or scheduling your uploads to avoid these limits.

Hope, that will help.

edwin_lee_2025
6 - Meteoroid

Ivan, thank your for taking the time to make a search about my issue... I really preciate it!

 

Here the things I did considering your tips:

 

1) Converted the field "invoice_date" to String.

2) Then, I established the connection with Power BI via Internet Browser.

3) After that, I filled out all the fields I had to: MyWorkspace, New Dataset (I want to create a new one), set the name of the Dataset (proyect) and the Table (data)

4) Finally, I ran my pipeline but I got the same issues:

 

  • Requiered fields cannot be empty
  • Finished running name_proyect.yxmd in 6.6 seconds  with 1 error  using AMP engine

 

Could be the reason of the problems the fact I am using a Free Count of Power BI?

 

Because as you see I did all the things you told me.

 

Thank you again.

 

Regards.

 

Labels
Top Solution Authors