Forum Discussion
Change type of data source
afk,
You can change source code in Advanced Editor. For more details, please review my reply in the following similar thread.
https://community.powerbi.com/t5/Desktop/Change-Data-Source-from-Excel-file-to-Oracle-Database/m-p/280211
Regards,
Lydia
- afk8 years agoAdvocate II
Hi Anonymous,
Thanks for your response!
I tried this and it works. But initially, my data connectivity was via import and I now would like to use direct query. I'm however unable to change this to 'direct query', is there a way to do this?
afk
- Anonymous8 years agoNot applicable
afk,
To use DirectQuery, you would need to re-connect to the Amazon data source and re-create the whole report.
Regards,
Lydia- afk8 years agoAdvocate II
Anonymous EEK!
There are quite a lot of pages and visuals in the report. Can you suggest any way to easily "copy" the pages and visuals onto a new report? Plus keeping the formatting and positioning of visuals?
Thanks
afk