Forum Discussion
Replace Excel data source with Power BI Dataset
Hi, thanks in advance for any help Is there an easy way to change the data source used in an Excel file to use a Power BI Dataset without having to redo any pivots already set up - simply change the...
CrazyHorse66
It is not possible to replace a excel source with power bi dataset, and it is also not wise to do so. Because Power BI dataset only supports live connection mode, which you cannot access query editor to pivot table and other transformations. I would suggest you to connect to the datasource of that dataset(only for import or direct query mode), then copy paste all other steps to the new query, for example(the steps marked with red):
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.