Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors