the query contains columns with complex types that cannot be loaded

[F2]

I am getting an error while creating a dataflow in power bi service. I have loaded the tables but i am getting the error of complex types that cannot be loaded. I need some help regarding creation of dataflows in power bi service. I have created the dataflow in power bi desktop but I don't know ho to create it in power bi service.

[v-luwang-msft]

Hi @F2 ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft]

Hi @F2 ，

The following article tells how to create dataflow   in power bi service,you could have a look:

Creating a dataflow

You also could learn more details from the below vidio:

Getting Started With Dataflow in Power BI Creating Dataflow – Part 2 of Dataflow Series

Wish it is helpful for you!

Best Regards

Lucien

[GilbertQ]

Hi @F2 

What is the error you are getting?

We need more details to assist.

And also what happens when you copy the Power QUery Advanced editor into your dataflow?