Forum Discussion
odbc error "Restricted data type attribute violation"
I still didn't find solution to the problem yet and Power BI has little use for me until this issue is resolved. I so much love all features of Power Bi and they all have little use unless i can pull my data.
I was also having the same issue, which was odd since I was able to make the same ODBC connection last fall. I managed to get it working w/ the following tweak to the query steps:
Upon seeing the failure, I would click Edit in order to access the failed steps in the query editor. I rewrote the "APPLIED STEPS" statements.
For the Source I rewrote w/ the following:
= Oracle.Database("<dsn name>", [HierarchicalNavigation=false])
After applying this, I could then see the various tables listed along with the associated Schema and Items (which I used for the followign step).
For Navigation I rewrote with the following:
= Source{[Schema="<schema name>",Item="<table name>"]}[Data]
Not sure if this helps, but it got me up and running w/ our various data sets.
JB