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 Odbc.DataSource options. Valid options are: CreateNavigationProperties, SqlCapabilities.
 
 
My configuration:
 
I have an Odbc connection to Firebird database in my server. 
I Installed PowerBi Gateway - personal (OK state).
I can get and refresh data from PowerBi Desktop.
PowerBi App - Gateway connections its on line
ODBC credentials are ok
 
Some body can help me?

 

Thank you very much

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

2 Replies

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

  • 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.