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 everyone! I'm having problems with some Reports that I want to Refresh at least 4 times a month.
The data comes from one Excel database downloaded from an intranet portal. This files have at least 10 000 lines.
I insert more data into this Excel database every week before using Power BI. Once I have all new data inside the Excel database I then open Power BI Desktop and hit the Refresh botton to update with the new data.
Here's the problem: every time I hit the Refresh data, all of my "Date" type columns go blank... I do not know why this happens all the time but apparently I'm doing something wrong.
Can anyone please help me with this?
Thanks in advance for your help.
Solved! Go to Solution.
Actually, it was a problem with the connection of Binary file .xlsb vs .xlsx.
Thanks anyway for your help!
@Mega79 have you ensured that column format in excel and power bi is of same type ie date ?
Yes, they are both in date format but when I refresh the data I get this message now:
OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.
So the problem only happens when hitting "refresh"? What happens when redo "get-data" from the excel, do all the dates load well?
Actually, it was a problem with the connection of Binary file .xlsb vs .xlsx.
Thanks anyway for your help!
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |