Forum Discussion

masplin's avatar
masplin
Impactful Individual
3 years ago

Model based on other Power BI datasets wont refresh

Hi. I have model linked to 3 other P{ower BI datasets.  This modle refreshes fine in desktop but in service I get this error

 

I have no idea what this means?  Makes it compeltely useless if I have to manually refresh the desktop model and publish it out rather than just refreshing the 3 datasets and expecting the joint model to pick up the new data.  Any advice appreciated

 

There was an error when processing the data in the dataset.Hide details

Data source error:{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi masplin ,

    According to your error message.You have used Direct Query connection mode in Power BI to connect to a datasource with a calculated column or a calculated table, which is currently not supported within the Power BI service.

    • Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used.
    • Calculated tables: You can use calculated tables in DirectQuery when using composite models.

    More details: DirectQuery in Power BI - Power BI | Microsoft Learn

    Use composite models in Power BI Desktop - Power BI | Microsoft Learn

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details .

    Best Regards
    Community Support Team _ Rongtie

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

     

     

    • masplin's avatar
      masplin
      Impactful Individual
      3 years ago

      So if I have calculated column that needs to use more than 1 row in thetable to generate an answer that will break the refresh? 

       

      Is there some other way to connect datasets other than direct query?  I dont seem to be given any choices when i created the join model.

       

      Very frustrating that only way to ge tthe model towork is open the desktop version and manually refresh then republish. Really don't understand why the desktop model can refresh but the service version cant?  Happens a lot with power BI generally a modle seems fine when you design it and falsl over when you publish it.