Forum Discussion
Direct query - data doesn't show in the published version "No available gateway' error
Hello,
I can see the data in the visuals on the desktop file, but I can't see it once I publish it to the desktop version.
The data is using direct query from PowerBI dataset.
What could be the possible issue?
- Anonymous3 years ago
Hi unicorns ,
Could you please provide the answers of the following problem for the further troubleshooting?
- What's data source of your report?
- Is there any other data source besides that Direct Query data source in your reprot?
- Did you configure the gateway and add the data source to the gateway? If no, you can refer this link to get.
In addition, the following blog describe the similar issue as yours. Hope it can help you.
All I could take away from this experiment is that Direct query does not seem to work if you have multiple data models and one or more of them is imported locally.
Best Regards
2 Replies
- AnonymousNot applicable
Hi unicorns ,
Could you please provide the answers of the following problem for the further troubleshooting?
- What's data source of your report?
- Is there any other data source besides that Direct Query data source in your reprot?
- Did you configure the gateway and add the data source to the gateway? If no, you can refer this link to get.
In addition, the following blog describe the similar issue as yours. Hope it can help you.
All I could take away from this experiment is that Direct query does not seem to work if you have multiple data models and one or more of them is imported locally.
Best Regards
- AnonymousNot applicable
Following the instructions of the blog post (taking out the Excel files from the project and connecting them by another way) worked for me. Thanks!