Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Configure Enterprise Gateway DirectQuery to AWS

Hi,   I am currently running an SQL statement via DirectQuery to get my data from an AWS cloud database.   When I publish the report to the service, I get the error as appears in the photo below....
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Yes, normally, if the data source is online, we don't need to add it to data gateway.

For your strange scenario, I need know more details.

Do you have other data source in this report? No, one data source

In addition, which connector do you use in Power BI? Get Data > SQL Server

Besides, could you see the data in the Power BI Service? If you mean on the reports, yes. Publishing fine, but cannot "schedule refresh" in the "Dataset" because of this enterprise data gateway error. 

 

All the best,

Dan.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I'm sorry that I don't have the enviroment to test with AWS.

You could check if it will remind you don't need a gateway in Power BI Service.

Normally, if your data source don't need gateway, it will remind you like below under Dataset.

If you still need help, please feel free to ask.

Best Regards,

Cherry