Forum Discussion
cheryl0316
Helper II
Helper IISwitch from live connection to DirectQuery - Can I edit tables in Power Query?
I created a Power BI report that connects to a semantic model via OneLake catalog. I’d like to make changes to the model, so I need to switch from Live Connection to DirectQuery—but none of the table...
Hello cheryl0316
When connected via Live Connection/DirectQuery, Power BI treats the semantic model as a read-only endpoint. If in your situation that I'd need to edit tables in Power Query, i would try creating a 'Staging Dataset' and 'Import Data' into a new PBIX. Then publish it as a new semantic model and reconnect those reports.
Hope this gives you some ideas:)
v-saisrao-msft
Community Support
Community SupportHi cheryl0316,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.