Refresh Error on Service

Anonymous · ‎05-22-2019

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 · ‎05-23-2019

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎05-23-2019

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 · ‎05-23-2019

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.