Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have an SQL datasource which only supports "read only application intents" (see Figure 1). The community solution to this problem is generally to "Enable SQL Server Failover Support" in PowerBI (see Figure 2). This solution works fine in the PowerBI desktop client however when I publish my report and datasource I recieve the following error. How can i enable SQL Server Failover support for a datasource once its published?
Additional References:
Figure 1 - PowerBI Desktop error without SQL Failover Support enabled
Figure 2 - Enabling SQL Server Failover Support in PowerBI Desktop
Hi @Anonymous ,
Make sure that you have got the permissions to add data sources to the Gateway in the Power BI Service.
Please refer to this blog:
BTW, currently for DirectQuery you can only use the Sql.Database .
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
4 | |
4 | |
4 | |
3 |