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 :)

arify's avatar
arify
Microsoft Employee
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 :)