Forum Discussion
DirectQuery reports not loading in PowerBI service
Hello all, Recently we installed an on-premises gateway with the aim of sharing reports that are based on data stored in SQL server. However, when using DirectQuery we get the following error mes...
Thanks for the replies!
Did some more research but our SQL server is on Amazon RDS. Is DirectQuery even a possibility then?
Hi there
I am not 100% sure, it would appear that it has to be a SQL Server source.
Can you configure it as a data source in the Gateway on the Power BI Service?
I am not 100% sure, it would appear that it has to be a SQL Server source.
Can you configure it as a data source in the Gateway on the Power BI Service?
It is currently configured with SQL server as data source type, which works when the data in the report is loaded in Import Mode. There is no separate option for Amazon RDS, only for AWS Redshift.
I've found an open idea here that would probably cover what we want to achieve, seems to be a topic since 2014.
- Hi there
It must be because it uses some other way to connect when using DirectQuery
I would think it should work if it is seen as a SQL Server source?That's what we thought, but that resulted in the error message from my first post.
When ticking the SSO box as you mentioned earlier we get a different error by the way: "This report couldn't access the data source. Contact [my name], the author, to have it fixed"