Forum Discussion
Converting to shared dataset
OK, one method that you can use is to create the new dataset. Create a blank report for that dataset (Live). Open your old PBIX, copy and paste visuals. Not fun but that should work as long as your data table names, columns and such are the same.
I have converted many reports to switch data sources using the Advanced Editor in Query Editor. However, I have never tried that method to convert between import and Live.
Correct, these are import models. I would like to replace this with the same dataset, but it will be a version that is certified and shared. So yes, i think the answer is it will be a Live connection?
Right now we are building new reports from the same dataset, then uploading. Causing duplicated datasets, just with a different name.
OK, one method that you can use is to create the new dataset. Create a blank report for that dataset (Live). Open your old PBIX, copy and paste visuals. Not fun but that should work as long as your data table names, columns and such are the same.
I have converted many reports to switch data sources using the Advanced Editor in Query Editor. However, I have never tried that method to convert between import and Live.
Greg_Deckler , Thank you once again sir! that's 2 posts were you able to help me with.