Forum Discussion

ani_informa's avatar
ani_informa
Helper III
5 years ago

'Role' is not a valid Amazon Redshift option.

Hi    I have created a Power BI report using Redshift Amazon db connector and I am pulling up data from a view. Everything is working fine on desktop version but when I published report to Service ...
Need Help
CobusEllis's avatar
CobusEllis
Frequent Visitor
5 years ago

Hi

I just got the same error. 
I removed the Role and Batchsize options from the end of the connection string and the connection is now working:
(Select the 1st step in your query and edit in the formula bar, or edit it in Advanced Editor)


I suspect something is not functioning correctly in the certified Redshift connector.


Kind Regards,
Cobus

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Removing Role did the trick for me too.