Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.