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.
I have an issue that I've been beating my head against the wall for weeks with. I have a vendor that has a web-hosted report that I need the data from. The report itself isn't useful, but they have an "Export to Excel" feature for it. The XLS file generated when I click that link always has the same name, but the data updates constantly. So, if you close Excel and open it back up a few minutes later, you'll see new data. Please note this report system is not on my personal network, but the vendor's, so using UNC paths or anything of that sort is out.
The issue I'm having is getting this data into Power BI automatically. I have a URI to this spreadsheet (though, again it doesnt "exist" until something requests it). When I try to use "Web" as my data source in PBI Desktop, I get "DataFormat.Error: External table is not in the expected format." I've tried OData and a number of other methods to pull the data from the spreadsheet, but nada.
Can anyone help?
Solved! Go to Solution.
That might be your problem then. XLS isn't very well supported. Can you get your vendor to export in either XLSX or CSV?
Is this an XLS file or an XLSX file?
That might be your problem then. XLS isn't very well supported. Can you get your vendor to export in either XLSX or CSV?
I actually did find a way to modify the URL to get the application to spit out a CSV instead of XLS. That is working much better. Thank you so much!
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |