leearls Tracker

Re: Table name too long

leearls — Wed, 06 Mar 2019 22:56:31 GMT

Thank you for your reply. We are testing the already created table name and columns in Netezza and realize this is the limitation there. My question is what is the Power BI limitation so that I can't use the table as a data source from Power BI? Our other tools allow it (SAP for example).

We are trying to determine the lowest number of characters allowed, illegal characters, etc. so we don't face problems later on.

Table name too long

leearls — Wed, 06 Mar 2019 17:39:11 GMT

We're creating naming conventions for a schema to use for various tools, and are running against Table Name too Long errors when using Power BI Desktop Report Server (January 2019). I have not found documentation that shows the limitations of either Table Name or Column Name length for Power BI Report Server (or service). Can someone help us find this? We don't want to use illegal characters either.

Tried Direct Query and Import on a table name of 128 characters that is not failing using other tools.

DataSource.Error: ODBC: ERROR [HY090] [Microsoft][ODBC] (11400) Table name too long.
Details:
DataSourceKind=Netezza
DataSourcePath=edwprd.carilion.com;EDW_PRD
OdbcErrors=Table

Thank you for any help you can provide. We need to document the requirements, and I am not finding on any MS whitepapers.

timeline slicer

leearls — Thu, 15 Feb 2018 21:14:31 GMT

I've been using Timeline Slicer for a few months, and it suddenly stopped working. I'm using Power BI Desktop (October 2017) to develop, matching our On Prem server version. When I publish, the viz displays, but I can no longer configure within Desktop. "Your version of Power BI Desktop does not support this custom visual. Please update Power BI Desktop to the latest version." I need to keep this version the same as my server, correct? Also - if this could include a setting to highlight through today's date, that would be helpful. Now, it only filters. I'd like to show YTD on the selector, but highlight MTD. And I can't do that.