[Redshift Connector] Issue with Direct Query on Power Bi Service

[prerak]

• According to these blog posts, POwer BI service now supports the Red**bleep** connector
  • [PBI Desktop] April Update
  • [PBI Service] March Update
• I am creating reports on some of my tables in PBI desktop and seamlessly publishing/consuming them on PBI Service.
• BUT
  • there is this one table I have that is throwing me a bizzare error

  • DirectQuery error: 
    DirectQuery may not be used with this data source 
          - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version.

  • Weird this is that I have got 2 tables in this PBI Report.
    • One loads all fine. The other one throws this error
    • Attaching Schema

      • CREATE TABLE public.organizations_godview_temp
        (
        	timestamp_post TIMESTAMP ENCODE ,
        	year_post INTEGER ENCODE lzo,
        	month_post INTEGER ENCODE lzo,
        	teamid VARCHAR(32) ENCODE ,
        	activity_type VARCHAR(64) ENCODE ,
        	event_category VARCHAR(64) ENCODE lzo,
        	event_action VARCHAR(64) ENCODE lzo,
        	event_cat_action VARCHAR(64) ENCODE lzo,
        	activity_count INTEGER ENCODE lzo
        )
        DISTSTYLE EVEN
        SORTKEY
        (
        	teamid,
        	timestamp_post,
        	activity_type
        );

      • Any ideas as to what is the issue for this particular table?
        • I tried changing table name, but to no avail.
        • I tried dropping all columns, except one, but to no avail

[v-caliao-msft]

@prerak,

Could please also provide another table's schema? Are there any special data type in this table? As a test, you could create another table in your source table and check if this issue persists or not.

Regards,

Charlie Liao