Change Data Source from Excel to Push Dataset

[imranamikhan]

Hello,

We are moving from Excel flat files as our source data to a PowerBI push dataset. Whereas it is quite straightforward to change a data source when moving from Excel to SQL Server Tables, SharePoint, OneDrive etc, is there a way to replace the data source from Excel to a Push data set?

I understand because we are using a live connection, a limitation is that modelling via the query editor is disabled.

https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets#limitations-and-consider...

regards,

ImranAmi

[mwegener]

Hi @imranamikhan ,

you have to differentiate between push dataset, live connection and direct query.

I think you mean direct query.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

push dataset: https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[imranamikhan]

Thanks @mwegener. Unfortunately I do not understand your response - you have provided documentation on push data and direct query but this is not at all relevant to my question?

The question is whether there is a way to change the data source for an existing PowerBI report from an Excel file to a Push Dataset.

[mwegener · Accepted solution]

Hi @imranamikhan,

from my point of view no.

The data sources are too different.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[imranamikhan]

@mwegener my thoughts too. Thank you for confirming