Forum Discussion
Error in Refreshing data in power Bi cloud
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
3 Replies
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.
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
hmm i found this older thread, might be best to log a support ticket to microsoft..
