Forum Discussion

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
3 years ago

Dataset with DirectQuery is not showing new measures and tables after refresh

Hi all,  I have 2 workspaces: Workspace "A" with Dataset "01" and report "01" Workspace "B" with Dataset "100" and report "100" My dataset "100" in workspace "B" is using dataset "01" from Work...
Need Help
CharbelArmaleh's avatar
CharbelArmaleh
Icon for Resolver II rankResolver II
3 years ago

Hello,

Can you try to check the lineage 

 

just to double check the source of the  Dataset "100"

 

Regards

 

  • Sergii24's avatar
    Sergii24
    Icon for Super User rankSuper User
    3 years ago

    I had to hide some values, but the schema is the same:

     

    • CharbelArmaleh's avatar
      CharbelArmaleh
      Icon for Resolver II rankResolver II
      3 years ago

      one more thing to check, if you activated the composite mode on the Dataset "100" you will need to add the calculated table i think

       

      try to click on get data --> Power BI dataset and select the table where the measure is 

       

      Regards

       

       

      • Sergii24's avatar
        Sergii24
        Icon for Super User rankSuper User
        3 years ago

        From PowerBI Desktop there is even no need to do so. Right after I refresh the report, all changes are immediately visible (new measure, new table, column etc.).

         

        The issue I have is with the dataset "100" refresh in PowerBI Service: changes of the dataset "01" are not visible after refresh online.