Get data in Power BI Desktop from an Excel file stored in OneDrive

[Cucharil68]

I'm having problems getting data from an excel file stored in my one drive.....When Power BI gets data from a file stored in my desktop I do not have any problem Power bi loads all  rows, but when I change the source to the same file , but this time stored in my one drive,Power BI only gets the first row. I noticed that if I take off the heading filter from the file stored in my one drive,  Power bi gets all the rows the same way as the file stored in my desktop, but the problem is that I have a flow that automatically save the file from my email, and it comes from another program with the heading filter on.....

Any Idea

[Anonymous]

@Cucharil68,

What do you mean that "change the source to the same file" and "heading filter"? Do you replace the existing Excel file in OneDrive? 

Regards,
Lydia

[Cucharil68]

When I place the same excel file with filters on in my desktop and in One drive, Power bi gets data only from my desktop file but not from my one drive, even it is the same file. If I take off the heading filters in my one drive file then, Power BI is  also able to get the data from the One drive file......

The solution would be easy,,,,,,save the file in one drive without filters, but as I said, I receive the excel file in my email from another program and micrsoft flow automatically saves it in my one drive.....The program that sends the file to my email, sends it with filters on, and I cannot mofify it

[Anonymous]

@Cucharil68,

Could you please post screenshots about your scenario? Please share the Excel files with filters to us if you can. You can send Excel file via Private Message.

Regards,

Lydia