Connect to Power BI services DataSet without live connection?

[Anonymous]

Hello PBI community,

As I've done a lot of data transformation inside The Query Editor, it slows my model at the point I can't even refresh it on the desktop.

So my objective is to create a "intermediary" DataSet created in PBI and publish on the Service.

My question is How can I access this dataset without using the live connection? (As the live connection doesn't allow you to use multiple sources)

Thanks in advance for your help

Regards

Mark Lovejoy

[Mariusz]

Hi @Anonymous 

You can create dataflows and later create a dataset on top of it combining dataflows with other sources.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Thank you for your help @Mariusz ,

in that case, how can I get the dataset? With what type of connector? Odbc?

Regards

Mark

[Mariusz · Accepted solution]

Hi @Anonymous 

When you in power bi you can do this.

When in the query editor do this

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.