Forum Discussion
Direct Query broken in Power BI Service (composite model)
I've read a lot of posts, but did not find the solution to this problem, so I hope anyone can help. I've created a fairly simple report in which I'm using direct query on 4 tables in an Azure SQL Ser...
Hi v-xuding-msft what I don't understand is that I'd need a Gateway as I'm only trying to connect to cloud resources...
In the end I think I managed to solve the problem by changing the way it loads the Excel file (that was the non-direct query part). In Power Query I've changed File.Content with a link to my personal OneDrive to Web.Content with a link to a shared Sharepoint (Teams) location.
After a few updates, this one is still not broken, so hopefully this was what caused the problem initially.