Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Based on the error message, you need to check if you have added all the data sources into gateway. And remember choose the following option.

Then match the gateway in the gateway connection.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.