Refresh Error on Service

[Anonymous]

I have a report that won't refresh on service. I get the following:

Information is needed in order to combine data;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: NPS

The pbix file refreshes normaly on desktop. The table NPS is a merge that I did on Power Query. The sources are SQL Server query and a xlsx stored on a blob container.

Anyone?

[v-cherch-msft]

Hi @Anonymous 

It seems you may install the gateway and configuring scheduled refresh to refresh data in service.

Reference:

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

Regards,

[Anonymous]

Chen,

I don't think that's the point. This specific report had scheduled refresehs that were working fine. I also have other reports refreshing normaly on the same workspace.

[v-cherch-msft]

Hi @Anonymous 

I cannot reproduce the same issue.You could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Regards,