Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Frixel , refer this to get a lastest file
In power Query you can use Table.RowCount to count the rows
https://docs.microsoft.com/en-us/powerquery-m/table-rowcount
@Frixel , refer this to get a lastest file
In power Query you can use Table.RowCount to count the rows
https://docs.microsoft.com/en-us/powerquery-m/table-rowcount
Click on "Transform Data" and it will open up Power Query Editor
Proud to be a Super User!
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.
Proud to be a Super User!
@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
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.
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
Proud to be a Super User!
The file is saved as html page so i choise that in powerbi and the the connection is solved.
Thanks for your help.
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |