Power BI Output Tool Error: Dataset must contain at least one table

BetoZM

Hello all!

I've been trying to export my dataset into Power Bi, but since yesterday, Alteryx has been giving me this error:

It's the first time that this happens, since I've been exporting a lot of datasets in the past.

This an example of the workflow:

As you can see I already cleaned my data and just Selected some rows that I need.

We are talking a lot of records so it's easy for me just to send the useful information.

This is what my Metada looks like after the SELECT:

I tried to have a lot of consistency through the whole process.

I also tried to change the data Type, from Int64 to Double, String to V_WString but without any luck

And just in case, this is what my Output for the Power Bi Tool looks like:

I'm running:

Alteryx Designer x64
Version: 2022.1.1.25127

Power Bi Output Version: 3.2.0

Error Message

Output

API

Power BI

Accepted answers

BetoZM

Yes.
It actually looks like that Power BI Output Tool can take a certain amount of Columns.

So I had to rework everything to have my data on rows and not Columns, I was trying to export around 30-50 Columns, maybe the API has it's limits.

hiratay

Got it. I just figured out the issue I had, which is due to rows exceeding 1M. Seems like there is limitation in both row and column counts when push dataset in Power BI.

Power BI REST APIs push datasets limitations - Power BI | Microsoft Learn

All comments

lina2481

Have you figured out a solution to this? I still have the same error.

BetoZM

Yes.
It actually looks like that Power BI Output Tool can take a certain amount of Columns.

So I had to rework everything to have my data on rows and not Columns, I was trying to export around 30-50 Columns, maybe the API has it's limits.

hiratay

Hello, how many columns you ended up with? did you change anything else in your setting?

hiratay

Got it. I just figured out the issue I had, which is due to rows exceeding 1M. Seems like there is limitation in both row and column counts when push dataset in Power BI.

Power BI REST APIs push datasets limitations - Power BI | Microsoft Learn

BetoZM

Yep, Power Bi Output would be the best solution for someone that doesn't even touch half if their limits, for someone that needs a lot of rows and columns, it's not even an option.

I found that CSV is reliable, but if you have anything else that will upload to Power Bi fast and can store a lot of data, I'll be happy to see it.

Thanks for the info though!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703