Forum Discussion
Not able to import new table from existing amazon redshift datasource
Hi,
I am trying to import a table from the exisitng data source "Amazon Redshift" but it not this data source is not showing up in recent data sources option.
When i refresh the data in my report it is getting refreshed using "Amazon Redshift" but I am unable to add any new table from here.
Any help is highly appreciated
Hi Anonymous ,
If you want to add a new table from the same database, maybe you can copy the whole code which you have posted before and create a new query to modify:
- Copy the previous code
- Create a blank query in Edit query
- Right click the Query and choose Advanced Editor
- Paste the code in Advanced Editor and modify the Name tab into the table you wanted to add
- Close and apply it.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-yingjlCommunity Support
Hi Anonymous ,
Maybe you can refer the following simliar case that could help you:
https://community.powerbi.com/t5/Power-Query/Adding-in-new-tables-from-same-datasource/td-p/100792
If not help, could please share more details like error messages or pictures for further discussion?
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- v-yingjl
Hi Anonymous ,
If you want to add a new table from the same database, maybe you can copy the whole code which you have posted before and create a new query to modify:
- Copy the previous code
- Create a blank query in Edit query
- Right click the Query and choose Advanced Editor
- Paste the code in Advanced Editor and modify the Name tab into the table you wanted to add
- Close and apply it.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.