Enterprise Gateway not accessible to my datasets.

[Anonymous]

I created a report on Power BI desktop with three data sources.

1 - A CSV file

2 - A ODBC connection

3 - I created a table using "Enter Data" and this table contains two columns - ID and a columns with images URLs 

On Data Source Settings, these are my data sources:

So, I added to the enterprise gateway the above data sources:

ODBC datasourceFile datasource

But, I am not able to configure my dataset to use the gateway:

 

What I have to do to fix it?

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Quite weird.

1. Please upgrade the Gateway to the latest version.

2. Try out the new ODBC format like this.

Best Regards,

Dale

[Anonymous]

@v-jiascu-msft, thank you. Using the new ODBC format worked!

[GilbertQ]

I am going to take a guess that it is your Enter Data that is causing the issue.
Could you put the Enter Data into a CSV file as you did with your previous CSV file, then add it to the Data Sources in the Power BI Service Gateway.

And then see if you get the option?

[Anonymous]

Hi @GilbertQ, I tried to do so. But the problem persists, so I installed a personal gateway and these are the data sources:

Data sources

MEDIDAS.txt is a new file that contains the values of the old table "Enter Data". So I configured it on the Enterprise Gateway:

But as you can see on the first image, the problem persists.

[GilbertQ]

Hi there

If you installed the personal gateway, you do not need to configure the data sources in the gateway.

You should just be able to edit the credentials for your 3 sources and it should then refresh.