Forum Discussion
Copy functionality of SSAS data schema to PBI desktop | Tabular editor
HI Team,
Is there any way by which we can migrate On prem SSAS tabular model ( data schema ) to PBI Desktop?
I know about AAS to PBI dataset which was recently released by Microsoft but in our case we are using On prem SSAS tabular server. one way is by using tabular editor we can copy paste table or measures from SSAS to PBI desktop but somehow this functionality also not working.
In one tabular editor instance, we are opening SSAS tabular cube for Model 1 and another tabular instance , we are connecting to PBI desktop local version (blank copy), while copy pasting table directly from tabular editor , it pasted the table succesfully but while applying the changes in PBI desktop , It is getting removed.
Is there any settings or configuration we are missing while doing this operation?
Thanks
2 Replies
- amitchandak
Super User
shubhamc_002 , I got this, please check if this can help(not fully sure)
https://data-marc.com/2020/06/16/migrate-analysis-services-models-to-power-bi-using-tabular-editor/
- shubhamc_002
Helper I
Thanks amitchandak ,
we have tried this approch but still issue is the same. DAX tables and measures are copying but physical tables are not copying.while applying the changes , tables are getting removed from PBI desktop .