Forum Discussion

gricart's avatar
gricart
New Member
10 years ago
Solved

Refresh error with odbc connection

Hello,   When I'm attempting to refresh my report information, I get the following error:     Tipo de origen de datos Error del origen de datos: Options HierarchicalNavigation are not valid Od...
  • arify's avatar
    arify
    10 years ago

    Hi gricart, it looks like the Gateway is using an older version of PBI than your PBI Desktop.

     

    If you want a quick workaround, you can delete

    HierarchicalNavigation=true

    part when you open the Query Editor (then, click Advanced Editor to see your M query better)

    (But after doing this, you need to change the navigation in your query, because now it will return you a different structured navigation table)

     

    Note: We're working on better alignment of PBI Desktop & PBI Gateway versions, so this problem will disappear very soon in general :)

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

gricart I have run into this problem before. When you connect from PBI to firebird database using Firebird ODBC it does a database scan to list all objects and the specific method it runs that fails via firebird ODBC. This has actually been fixed in PBI desktop. However I haven't been able to test it with Powerbi.com. I would suggest you update your version of firebird ODBC and try. Meanwhile I will try it with personal gateway and let you know if it throws error to me as well.