Direct query - data doesn't show in the published version "No available gateway' error

[unicorns]

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? 

[Anonymous · Accepted solution]

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.

{Solved} "There is no available gateway" - Error while connecting to DataVerse from Power BI using D...

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

[Anonymous]

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!