Forum Discussion
wonga
10 years agoContinued Contributor
Connect to OBIEE RPD using ODBC Connection
I'm trying to connect to the repository for OBIEE using an ODBC connection and the list of subject areas appears to load in Power BI, but I am unable to load any data into Power BI in order to make v...
arify
10 years agoMicrosoft Employee
Hi wonga, this looks like a new bug. Can you please send us a frown? We'll fix this soon. The reason is, (at least) one of the columns is really big. Do you have a guess which column is the big one?
In the meantime, I can give you a work around to remove that column for now (hopefully you don't need that column immediately) :
- Open your table in the Query Editor & get the error
- In the ribbon, there's a Keep Rows button. Click "Keep Top Rows" in there and enter 0 to the "Number of rows" field. Click OK.
- Now you should be seeing the columns. Right click on the column you think is the big one and click "Remove".
- On the right side where you see the "Applied Steps", click the X next to the step that removes the rows (if you're using English PowerBI Desktop, the step's name is probably "Kept First Rows").
- It'll give you a warning. Click "Delete" on the prompt. Now you should be seeing your table without that column.
Please let me know how it went :)
Thanks
wonga
10 years agoContinued Contributor
arify I am not able to load any tables when connecting through ODBC. After I input the query as you laid out, it gives me that error regarding array dimensions.
The "Keep Rows Button" is greyed out, see below screenshot for more information. A frown was sent on 7/25 regarding this issue.
Thanks.