Solved: report server direct query sql server

ebr · ‎09-12-2017

I have created several dashboard, with different data sources. Those that are fed through the SQL database import work fine and I can view the data in Power BI Server.

But those that are fed through SQL Database Direct Query do not work. I can create the control panel in Pwer BI Desktop (June 2017), but when I load these dashboards in Power Bi Report Server, these dashboards are not displayed.

Does anyone know why? Can someone help me?

v-qiuyu-msft · ‎09-12-2017

Hi @ebr,

It's a limitation that DirectQuery data connections are not currently supported. For more infomration, see: Connecting to data sources.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-qiuyu-msft · ‎09-12-2017

Hi @ebr,

It's a limitation that DirectQuery data connections are not currently supported. For more infomration, see: Connecting to data sources.

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.