Error using AMP engine | Power BI Output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- AMP Engine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your comments.
Here is the workflow...
Wait for your reply, thank you again.
Edwin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you upload the entire workflow or a screenshot of the Power BI tool configs? Sorry for the confusion.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank again for your reply.
Could you please give me more detail about the configs you want to see?
Regards.
Edwin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
