Problem import data model Power Pivot into Power BI

[Anonymous]

Helle everyone,

I'm a beginner with Power BI and I would appreciate your help.

In Power BI, I did :

-> file -> import -> excel

The aim was to import data model from power pivot. But, Power BI showed me an error message and loaded all tables except one.

Do you know how to fix that ?

thank you in advance.

[v-chuncz-msft]

@Anonymous,

You may take a good look at Query overview in Power BI Desktop.

[GilbertQ]

Hi there

What was the error when you clicked on the error after the import?

[Anonymous]

Hello,

did you have the time to look at my message ?

thanks.

[GilbertQ]

Hi there,

If you could private message me and I can then let you send it to my email address.

[Anonymous]

I've sent you an example of the file via a private message.

thank you,

Angélique

[Anonymous]

Hello,

at the end it's difficult to send you the file because of confidential informations that are in it.

The message of error I got is that there are too many lines in the table but I'm surprised because there are only 30'000 lines.

Do you know how to solve this problem ?

thanks.

[v-chuncz-msft]

@Anonymous,

If possible, just illustrate with dummy data.

[Anonymous]

There is no detail of the error. Would it be a possibility to send you an example of the file ?