Forum Discussion

BosJelle's avatar
BosJelle
Regular Visitor
2 years ago

Integrated DirectQuery data with Imported data cannot be published to workspace

Hi!    I have a 'master' report with master data and 2 other reports from which I DirectQuery data into the master report. I want to combine the master data, with the data from the other two report...
Need Help
BosJelle's avatar
BosJelle
Regular Visitor
2 years ago

Thank you for your answer!

 

Using relationships, how would I make sure that the visualisations on my page will show the master data, except when similar data is found (e.g. based on 3 similar columns) in one of the two other tables? Do I need to make a measure? And if so, how?

 

Please, let me know!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi   BosJelle 

 

To display master data in a visualization, you need to create relationships between tables based on common or related columns.Power BI can detect and create relationships automatically, or you can create them manually.

 

You can view the link below for more details:

 

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

 

Regards,

Nono Chen

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

 

  • BosJelle's avatar
    BosJelle
    Regular Visitor
    2 years ago

    Hi!

     

    Thank you for your answer but unfortunately this does not answer my question. Here some more context:

     

    I want to show the master data in my visualisations, except when there is data from that particular project in the directquery. This can be based on project name. The method does not really matter (e.g. relationships, query). However, I need to be able to publish it to the workspace.