Forum Discussion
Power BI (Get Data --> Web) throwing error while the url provides the data
I'm currently working on a Power BI report for my business, and the data for it comes from a report URL given by another internal team in my organization. The report URL retrieves data and also exports it to a CSV file. However, I get an expression error when I put data into Power BI or Power Query (Excel). Expression.Error: There weren't enough elements in the enumeration to complete the operation. Details:[Table]
Additionally, I get an expression error when Power BI promotes the headers and detects the column type. Expression.Error: The column 'id' of the table wasn't found. Details: id and this will continue for all other columns. I'm not sure what's going on with Power BI, but I've done some research and combed through all the posts/forums, but they have come up empty.
Several items to share: There is no column with the same name, no space in the column name, and nothing in the data source has changed. It has been verified by the team responsible for giving the report's URL. Could someone assists me about what the issue is here or what I am doing incorrectly?
4 Replies
- lbendlin
Super User
It is always a bad idea to specify the column count during CSV import. Unfortunately that is what Power Query does by default. Remove the "Columns = 39" part from your code.
That didn't work
- lbendlin
Remove the "Changed Type" step too - you will want to control type conversions yourself. Maybe you can provide a sanitized version of your Power Query code?
I am still getting the Expression.Error: There weren't enough elements in the enumeration to complete the operation. Details:[Table].
