I have a shared dataset using the default Live Connection but want to convert to DirectQuery to add additional data sources. When I click the "Add a local model" button in the dialog box, we get the following error:
The feature was working several months ago. We're currently using the June 2021 version of Power BI Desktop.
Any ideas on this issue?
Start by updating to the latest version of PBI Desktop would be my first suggestion.
Check the settings for the feature would be my next.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Can you connect to that dataset from a new PBIX?
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Yeah, I see what you're saying, I just picked one of my datasets at random and clicked the 'make changes...' and I got the same error as you.
I tried a different dataset in a different workspace and I was able to make changes.
Then I tried to add the original dataset back in and got this error...
Something definitely seems to be wrong.
There is this old post that seems to be a similar issue.
I'll see if I can figure out any relationship between the issue and workspace/dataset I tested.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Are any of your data sources streaming datasets?
I am able to make changes as expected if I don't accidentally choose a streaming dataset.
Maybe check the tenant admin settings to ensure an update hasn't gone and turned something off? Something around the 'Allow XMLA Endpoint....'
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
