Forum Discussion
Table 'LocalDateTable_2a2cf38a' with ShowAsVariationsOnly property set to '1' must be a target of
I am stuck with one of my reports. The model in my pbix is a mix of Excel Files and MySQL database tables. I created a query table using Union/Selectcolumns from these tables and it was all working f...
Hi PranshuJ
try a solution from here https://community.powerbi.com/t5/Desktop/Data-Modeling-Help-ShowAsVariationOnly-Error/td-p/226859
do not hesitate to give a kudo to useful posts and mark solutions as solution
tried this one and was able to unselect the "Auto Date Time" but when I turn it on I get the same error message and that it is unable to make changes to the server
hi PranshuJ
Please update your Power BI desktop to the latest version to try it again. If the issue still occur, kindly create a support ticket for help of you are a pro user.
https://powerbi.microsoft.com/en-us/support/
Regards,
Lin
hi PranshuJ were you able to fix this? I am having the same issue! #help ?
