Underlying error message: The column 'Column1' of the table wasn't found

[LDomingues]

Hi,

I'm having problems connecting to the mashup data source.

This dataset works fine in desktop, though when refreshing the dataset in the app, it says that cannot find column 1 of the table.

There are many databases connected, how can I know which table is refering to?

Thanks

[LDomingues · Accepted solution]

Problem Solved!

The problem was in my data sources on my manage gateways.

I had two data sources, one with the full path URL and other with small path URL

Example:

FP - Data source settings URL: https://out.pragma.pt/Afluencias/rest/Afluencias/Todas

SP - Data source settings URL: https://out.pragma.pt

After deleting the FP URL, the refresh started working fine.

For my experience we should always connect to a datasource when managing gateways with the small path.

[venunm]

I get the same message but when I get to 'Manage gateways' I do not see any data sources there. I tried to re-install personal gateway but it fails asking me to uninstall. I do not know where the previous personal gateway is stored to un-install or re-run.

How do I get this work?

[LDomingues]

After doing some research, I found the problem of the error message.

The thing is that I'm connecting to a web service (JSON), and my source is a list. When I transform it in SQL to a table (table from list) it is created a column1 with all records.

The refresh problem is in this column.

In Desktop this source works/refresh fine.

Advanced Editor:

let
Source = Json.Document(Web.Contents("https://out.pragma.pt/Afluencias/rest/Afluencias/Todas")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"CodigoAtivo", "Ativo", "Entrada", "Data", "Hora", "VisitasIn", "VisitasOut"}, {"CodigoAtivo", "Ativo", "Entrada", "Data", "Hora", "VisitasIn", "VisitasOut"})
in
#"Expanded Column1"

Does anyone knoes how to resolve this?

Tks

[v-haibl-msft]

@LDomingues

You can go to Power BI Desktop – Query Editor – Advance Editor to check if there is any step in your queries references this missing column by name. Then you can correct it and try again to see if the error can disappear.

Best Regards,

Herbert