Error in Refreshing data in power Bi cloud

[lochanam]

Hi All,

The poerbi desktop file refreshes without errors. But when i publish it and refresh it gives the following error.

My datasource is MS SQL on cloud.

PLEASE HELP TO RESOLVE THIS.

There was an error when processing the data in the dataset.

Data source error:	{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Microsoft SQL: Invalid column name 't0_0'."}}],"exceptionCulprit":1}}} Table: Production.
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	ec964bb6-85bb-42b0-b8e3-76a4220b7f8d
Request ID:	7b594ef1-5825-52d6-a975-24d5cc2c71ef
Time:	2021-01-24 05:00:03Z

Thanks & Regards,

Lochana

[vanessafvg]

have you ever published it successfully or other dashboards from this source before?  are you sure you connecting to the right server.   How is your file set up to refresh in the service.   

[lochanam]

Hi @vanessafvg ,

I have published reports using the same source and they are refreshing without errors, both manually as well as scheduled. 

I have few others when published gives the above error, but refreshes without errors when refreshed through the power bi desktop.

Thanks,

Lochana

[vanessafvg]

hmm i found this older thread, might be best to log a support ticket to microsoft..

https://community.powerbi.com/t5/Issues/Problem-with-PowerBI-server-refresh-Microsoft-SQL-Invalid-co...