Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 source of the data?
We we can create an excel file with the connection to the PBI dataset, but in a new/blank workbook only.
@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.
Hi @CrazyHorse66 ,
You can simply replace the data source using the data source settings
Just make sure data structure is the same.