Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello, I have a published data set that has gone to display the following error: Microsoft SQL: The database function does not support the 'MultiSubnetFailover' query option with the value 'true'. I have already verified all queries and corrections are correct and are available in Power BI Desktop are correct.
Can you help me?
Hi @dafalne,
I think the error message has clearly told that current power bi not support this feature.
In my opinion, I'd like to suggest you vote below idea which has the same requirement:
Ability to add MultisubnetFailover parameter to SQL Connection
Regards,
Xiaoxin Sheng
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |