Forum Discussion

prerak's avatar
prerak
Advocate I
9 years ago

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

  • According to these blog posts, POwer BI service now supports the Red**bleep** connector
  • 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
Need Help

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    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