Forum Discussion

unicorns's avatar
unicorns
Icon for Helper II rankHelper II
3 years ago
Solved

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? 

 

  • Anonymous's avatar
    Anonymous
    3 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.

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

    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

  • Anonymous's avatar
    Anonymous
    Not 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.

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

    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's avatar
      Anonymous
      Not 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!