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

Sorry, did not include much info in that...

On Power BI Desktop, I have tried going to the Transform Data / Clear Permissions and that did not seem to fix the problem.

 

Also, on the Power BI Service, when I look at the Lineage view it has the two existing data sets coming from ODBC connection into the dataset with the same name as my report. When I go to settings for my dataset it has an error 'One or more cloud data sources for this dataset have been deleted. Recreate cloud data sources (link)'  Clicking the link does nothing.

 

When I look at the two existing datasets, they are refreshing successfully as there is a report for each of the ODBC datasets and they are loading fine in the Power BI Service.

 

Also when I load my report in BI Service it has an error 'There is no avaiable gateway'

 

I am confused as to why the Desktop is working ok??

 

Thanks again

Noob Nick