Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error refreshing Composite model live connection to Power BI dataset

I have a composite model that combines a direct query to a Power BI dataset in the service with imported data from Excel/dataflow. When I try to refresh in the service to re-import the non-live data ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am getting the same error, with exactly the same set up as you. Are you able to refresh the dataset locally on Power BI Desktop?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Yes it all processes successfully in desktop. Only the refresh in the service errors. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Do you have any calculated tables in your composite model? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I do, a date table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I found that if I removed the calculated table it would refresh in the service without this SSO error. Still waiting to find out if this is a known limitation as from what I see in documentation this should work.