Forum Discussion
Change type of data source
Hi,
The current data source of my dashboard is a CSV file on my local machine. I now have this data in Amazon Redshift, but Is it possible to change the data source to this?
When i go to 'Data source settings' and then 'Change source', it doesn't show me an option to Redshift. Is there a way this can be done without re-creating the entire dashboard?
Thanks!
5 Replies
- AnonymousNot applicable
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- afkAdvocate 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
- AnonymousNot applicable
afk,
To use DirectQuery, you would need to re-connect to the Amazon data source and re-create the whole report.
Regards,
Lydia