Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
megank's avatar
megank
Icon for Power BI Team rankPower BI Team
5 years ago

It should only impact measure-only tables (no columns at all). If the columns are just hidden then we don't expect to see this error. 

 

We'll look into the other issue today. I'll reach out if I need more info!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

megank 

Here's the error about "RELATED" formula not working.

  • megank's avatar
    megank
    Icon for Power BI Team rankPower BI Team
    5 years ago

    Thanks for the screenshot, Anonymous ! I confirmed with the team that this is by-design. Basically RELATED is not supported for weak/limited relationships, which includes cross-island relationships. This is the same behavior you would see if you were to have a composite model with two SQL DirectQuery sources (because they're in different islands), you can do this for import tables because they're all in the same (local) island.

     

    You can find more info about this on the RELATED function docs here: RELATED function (DAX) - DAX | Microsoft Docs and the section on Limited relationships her: Model relationships in Power BI Desktop - Power BI | Microsoft Docs