Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
Does the "DirectQuery" connectivity mode (to a sql server database) work for powerbi reports? It works when on PowerBI Desktop (report server) but as soon as it is published it fails with:
Something went wrong
Unable to load the model
Please try again later or contact support. If you contact support, please provide these details.
Request ID03f76e0f-0164-ab35-a42b-2ccdb7109b1f
TimeMon Oct 16 2017 11:35:21 GMT+1300 (New Zealand Daylight Time)
Version14.0.600.379
Will it be enabled in the next GA release?
Jaco
Solved! Go to Solution.
Hi @Anonymous,
Please refer to Jon-Heide's reply here.
Regards,
Yuliana Gu
What is your data source? It was orginally released just with live connectivity to SSAS.
A SQL Server 2016 database
Hi @Anonymous,
Power BI Report Server August Preview doesn't support DirectQuery data connections, apart from Analysis Services live connections.
Please see this article: Connecting to data sources
Best regards,
Yuliana Gu
Hi Yuliana
Will it be supported in the next GA release?
Regards,
Jaco
Hi @Anonymous,
Please refer to Jon-Heide's reply here.
Regards,
Yuliana Gu
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |