Forum Discussion
Paginated Reports: ODBC Data Source Connection String Is Not Supported
There's a solution! There's two workflows for adding data sources and the one I shared above has an issue. The scenario that worked was to go directly to the managed gateway settings and add a new data source and follow the steps for adding an ODBC connection. Screen shot is below. Afterwards, I published the report using the same connection string with success.
Thank you bradsy and GilbertQ for providing input on this.
Hi scottdigs
Unfortunately Snowflake is not supported for Paginated reports, you can see the list in below. (I do know the example you referenced says so)
Supported data sources for Power BI paginated reports - Power BI | Microsoft Docs
Hi GilbertQ,
Would you elaborate? My issue is with ODBC data sources, which Paginated Reports does support. I'm aware there isn't native support for Snowflake, but that is different.
Please see Microsoft's documentation here on ODBC connections and also notice that they use Snowflake as an example: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-odbc-support
