cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Manage relationships and use multiple datasets

Hi all,

 

I have a premium account for Power Bi online and I need to create a dashboard that is automatically updated there (not Desktop).

 

I have 4 datasets, which cannot be combined into one. They are imported into the Premium workspace and are scheduled to be refreshed. Then I need to manage the relationships between these datasets and build my dashboard onto the PowerBI online premium workspace directly.

 

Can you please advise me how to do this? I see there is no data modeling on the web app, but there just has to be a way to achieve this, right?

5 REPLIES 5
Burningsuit
Resident Rockstar
Resident Rockstar

Hi @Anonymous 

You can do this, but you start by using Power BI Desktop. In Power BI Desktop you can connect to a published Dataset, just select "Power BI Datasets" from the data sources. You'll be shown the Datasets you have access to. This will create a live link to the published Dataset. Currently you can only connect to one Dataset at a time, but there is a preview option - called "Direct Query for PBI datasets and AS" that will allow you to connect to multiple Datasets and create relationships between them, then report on the resulting "Composite Model".

This is more that I can describe here, but I have written about it .. Power BI Composite Models | What’s The Big Deal? | Burningsuit

A Composite Model, basically a model built of models can be very powerful and looks like it will do what you want.

Hope this helps

Stuart

Anonymous
Not applicable

Thank you for that. I'm afraid that even with DirectQuery enabled, I don't see the option to  make changes to the model.

Even so, if it's al on desktop and I publish it after, would that still allow me to have the Service (online app) report refreshed? Because normally after publishing from desktop, no subsequent changes from desktop are reflected in Service.

Hi @Anonymous 

You probably don't see the option to make changes to the model because you haven't enabled the Preview Option "Direct Query for PBI datasets and AS". That said you can't make changes to the Data Model but you can import other Data Models and make relationships between them, essentially building a "Data Model of Data Models".

Once the composite Report is published the refresh will depend on the Datasets feeding it, when they are refreshed the data in the Reports will update. Making material changes to the Visualisations in the Report will need to be done in Power BI Desktop and the Report re-published.

Hope this helps

Stuart

Anonymous
Not applicable

Hi @burningrage 

 

I did enable it, even tried ticking and unticking several times. Closing and opening the application and even restarting the whole PC. Could it be that I'm missing a step?

 

Emilia_0-1637919603518.png

 

I, too, cannot get this to work after enabling the feature in settings. Once I connect to one Power BI dataset, my "Get data" options become grayed out. 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors