Forum Discussion

NJCLIFFORD's avatar
NJCLIFFORD
Frequent Visitor
4 years ago
Solved

Error connecting to data

Howdy,  Created a report linking to two already existing datasets and a few tables off an import from Excel.   On desktop the visualizations using existing datases are showing ok, but when I publi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi NJCLIFFORD,

    For this error,

    please check the gateway connection in dataset settings, configure gateway for your data source.

    At the same time, you said when you load my report in BI Service it has an error 'There is no available gateway', I notice that you have a excel file data source in your report, you should also configure gateway for it.

    Simply put, your report is a composite data source and you need to configure the gateway to the local data source first. For more details, please refer to this doc:

    Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

     

    Best regards, 

    Community Support Team Selina zhu 

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

NJCLIFFORD's avatar
NJCLIFFORD
Frequent Visitor
4 years ago

Howdy, thanks for the quick response...

I have gone to Settings -> Manage Gateways -> Data Sources and there are a lot of names under there with status etc

I have found the two there that match the names of the Data Sets I am using, and the Status on them when I click the icon shows as Unknown Error - see image below.