Forum Discussion
Tabular Model processing SQL Agent Job failure
I have set up a SQL Agent job to process my tabular model db, but I am getting the following non-descript error. The tabular model processes fine processing it manually, but when I do it via SQL ...
I have found an issue in my SQL view where I combine multiple columns of which the nature is the same, but the columns are not the same data type eg varchar and int.
Casting them to be the same solved my problem
Hi Anonymous,
AFAIK, XMLA write operations on datasets authored in Power BI Desktop and published to a Premium workspace require enhanced metadata, did you enabed this on your dataset?
Using enhanced dataset metadata in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng