Refresh error with odbc connection

[gricart]

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

[ankitpatira]

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

[arify · Accepted solution]

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 🙂