Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Proud to be a Super User!
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..
Proud to be a Super User!