Look every day to another file

[Frixel]

Hi all,

Is it possible to have powerBi look every day at a new file  to count how many lines there are in that file?

The file`s has a different name every day similar to the current date as shown below.

[amitchandak · Accepted solution]

@Frixel , refer this to get a lastest file

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

In power Query you can use Table.RowCount to count the rows

https://docs.microsoft.com/en-us/powerquery-m/table-rowcount

[Frixel]

Hi @amitchandak  & @FarhanAhmed 

thanks for your help i will try it.

But what to do here?

[FarhanAhmed]

Click on "Transform Data" and it will open up Power Query Editor

[Frixel]

@FarhanAhmed & @amitchandak 

Now i get this 😥

[FarhanAhmed]

You need to install Excel Engine Driver installation on your machine.

you can download the driver and install it from

https://www.microsoft.com/en-us/download/details.aspx?id=54920

or you can also follow the link in error to download driver.

[Frixel]

@FarhanAhmed & @Syndicate_Admin

I can`t install that driver 😂

I have try the 64 bit and also the 32 bit.

This is my office version. (work laptop)

And this is the laptop

[Frixel]

Hi @FarhanAhmed & @Syndicate_Admin

Now i Can install the driver with this solution.

I have now install the 64 bit version and now i have a connection.

[Frixel]

Hi @FarhanAhmed  & @amitchandak 

Now i have this error, is that normal?

[FarhanAhmed]

Haven't faced it before 

see if this could help

https://community.powerbi.com/t5/Desktop/External-table-is-not-in-the-expected-format/td-p/153986

https://stackoverflow.com/questions/63556733/how-can-power-query-be-changed-to-handle-external-table...

[Frixel]

The file is saved as html page so i choise that in powerbi and the the connection is solved.

Thanks for your help.

[FarhanAhmed]

You can get it thru

1- Get Data using Folder, this will bring contents of files in that folder

2- Filter the extension to show on "xls" files

3- Then in Date Created filter using Date Filters to get the Latest file. This will always bring the latest file from folder

4- Expand the content of the file, make sure that you have consistent data on those files to perform next steps.

Hopefully this will help you on getting the data required.