Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Connect to Power BI services DataSet without live connection?

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
6 years ago
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.

3 Replies

Mariusz
Community Champion
6 years ago
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
  Not applicable
  6 years ago
  Thank you for your help Mariusz ,
  
  in that case, how can I get the dataset? With what type of connector? Odbc?
  
  Regards
  
  Mark
  - Mariusz
    Community Champion
    6 years ago
    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.