Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power BI composite model dataset is not getting refreshed | SSAS_ShortMessage_ProcessingError

Hello All,

 

I am trying to combine existing semantic models with direct query and 2-3 tables in import mode from databricks into single Power bi file, I have created some reports using these two data sources. data refresh works well from databricks and other source semantic model shows updated data in power bi desktop.

But when I publish this report to service, dataset is not getting refreshed, it shows below error which I am not able to understand, i have checked similar issues in the community but could get through.

 

Dataset refresh issue :

 

 

 

as anyone gotten this to work?

  • Hi. Please make sure you have configured the imported data credentials for the semantic model. Check if all conections are ok. If you are importing onpremise or a source that requires a gateway, make sure you have one configured as hybrid allowing cloud and onpremise conections at the same time.

    I hope that helps,

2 Replies

  • Hi. Please make sure you have configured the imported data credentials for the semantic model. Check if all conections are ok. If you are importing onpremise or a source that requires a gateway, make sure you have one configured as hybrid allowing cloud and onpremise conections at the same time.

    I hope that helps,

  • Anonymous's avatar
    Anonymous
    Not applicable

    I tried it with 1st VNet setting, but today I tried with below one to that and it worked, not sure what was the issue with first.

     

    Thanks for your help, appreciated.