PowerBi and excel dataset connection

[Syndicate_Admin]

Hello:

I am working on a PowerBi which I have fed with spreadsheets from Excel, now I need for the same Powerbi file to make a connection with a Powerbi dataset, they are datasets available from the company. However, when I try to make the connection I get the following message:

Is it not possible to work with both data feed sources for the same file?

[Syndicate_Admin]

Hello, I have the same problem, did you get to solve it?

😖

[amitchandak]

@Syndicate_Admin , when you create a live connection, you can not add another datasource. Or when already have connection you can not have live connection

Create a file with a dataset live connection, change it to a direct query from modeling and then add other files

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...