Forum Discussion

K3ph4s's avatar
K3ph4s
Regular Visitor
1 year ago
Solved

Error fetching data for this visual

Hi community, I have a huge issue I do not know how to solve: I have some BI models A,B,C A BI Model is databased, that is linked into B and C as the "powerBI Sematic Model"   In my B and C mode...
Need Help
  • nandic's avatar
    nandic
    1 year ago

    K3ph4s , addition to my previous reply.
    I created relationship between table from existing model with table from new source.
    And after dataset refresh on Power BI Service, it throwed me the same error as in your side.

    The issue is because i created relationship between table which is now in directquery model with table which is in import mode.

    Then i created new table via directquery and when i tried to add new column, it throwed me error when i tried to use "LookupValue" function.
    Which means this function doesn't work when using directquery mode.

    So in your case, i think it is easier to take pbix file that is already published for model A, duplicate it and then within this new pbix file to add tables for model B and model C.
    So not to have composite model (link to published dataset + new data sources), but to have all tables within new pbix file (new dataset).

    Cheers,
    Nemanja Andic

K3ph4s's avatar
K3ph4s
Regular Visitor
1 year ago

Morning nandic  thanks for your response,

Credentials are up to date and reviewed.

let me explain it better:
Model A: contains databases from Excel that will need to be included in models B and C as is the standard information to be compared with models B and C (project models)

Model B & C: Project Model with information from the specific project. These models contain information from a data cloud source connection with Autodesk connector (API to connect the Autodesk database). These models also contain the information from Model A (connected through Power Bi Semantic Model). Then I create many new columns comparing  the data between MOdel B (project Data) against Model A (Standard Data),

 


Formula for example:

 

QA_ReviewsSiteName = IF(
    ISBLANK(
        LOOKUPVALUE('Model A'[Site Code],'Model A'[Site Code],'Model B'[Site Name])
    )
    ,"No"
    ,"Yes"
)

 

The results of this new columns are use to show charts of QA, such as:

The charts and the formulas work perfectly in the editable Model. However, when I publish this data to the cloud, then, I receive the following issues:

and see details shows:

 

 

Hopefully, it is a clear explanation

 

Regards