You cannot change a data source type (e.g. .scv --> sql server) You have to copy-past every calculated column, measure and relationship one by one and then finally delete the Original data source tab and rename the new one back to the old name.
5 Comments
- I propose we support this idea, because it would solve this problem among others: https://support.powerbi.com/forums/282523-bi-in-sql-vnext/suggestions/7054789-add-a-data-model-language-for-ssas-tabular
- This would be extremely useful for me
- Totally, I only just discovered that it doesnt work. Is usueful when your delevlopment team tells you what the data structure will be like, and you can use a temporary CSV to program the required steps before your development team is done.
- Yes please, for the reasons below. I need to reformat a dashboard for a potential new client. I would like to dummy up the data quickly, and moving the source from sql to csv would be a huge help.
- Status added:New
