Forum Discussion

BenCardineau's avatar
BenCardineau
Helper I
5 years ago

composite model refresh

Hi all, I am using a composite model in PowerBI service (made of an Azure SQL database and an imported excel file), so that I can change (with the use of PowerApps embedded in the report) some value...
Need Help
nickyvv's avatar
nickyvv
Most Valuable Professional
5 years ago
Hi BenCardineau,

This message might be related to the data privacy settings of the data sources.
Can you check those in Power BI Desktop and make sure they have the same setting?
  • BenCardineau's avatar
    BenCardineau
    Helper I
    5 years ago

    Thx nickyvv , good idea!

    ... but unfortunately both DQ and Import sources are set to None (I tried both Public, same result), so I guess there must be sth else... ğŸ˜­

    Ben

    • v-xicai's avatar
      v-xicai
      Community Support
      5 years ago

      Hi BenCardineau ,

       

      If your dataset contains not only the cloud data source but also the on premise data source, then it needs to use the gateway,  and you may configure schedule refresh. See more : On-premises data gateway , Add a data source ,  Configure scheduled refresh .

       

      Note that you also need to select "Allow user's cloud data sources to refresh through this gateway cluster" option under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.

       

      Best Regards,

      Amy 

       

      Community Support Team _ Amy

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