Cannot load model with Red shift as data source

[Rayzo92]

Greeting all , 

in one of my Power BI project , i have a project that have a direct connection with Redshift AWS .

my client wanted to add new views , i added the views on AWS and i imported them into Power BI desktop but the problem when i publish the report in power BI service i have this issue : 

if i remove the new views that i imported on power BI desktop and i publish the report it works fine . i have a gateway for it and the gateway works fine .

any idea ?

Thanks all in advance 

[Anonymous · Accepted solution]

Hi @Rayzo92 ,

1. Does the report have RLS configured? If yes, verify the RLS role for the user.

2. You are using direct query mode to connect to a data source. Do you set database credentials and add data source to gateway? 

3. What mode of gateway you use, personal mode does not support direct query.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data