Forum Discussion

d4rren's avatar
d4rren
Frequent Visitor
2 years ago

Service refresh issue - please help

Hi I created a report with a mixture of a web connection (leankit), excel file on my PC and connection to SQL.  This report works fine and refreshes on my desktop version but when published and refre...
Need Help
Tips and Tricks
d4rren's avatar
d4rren
Frequent Visitor
2 years ago

thanks for your suggestion v-jiewu-msft

 

I have checked all datasources have the same privacy level and I turned Data connections on.  Still erroring on refresh.  The detailed error message is in my first post.  I was wondering if it is something to do with my leankit connection, as this is a web connection should it appear in the 'Cloud connections'.  I added this in, still no good.  As mentioned, this works fine on my desktop.

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi d4rren ,

Based on my testing, I can successfully refresh. You can follow the steps below:

1.You can check the leankit connection settings and Privacy level.

2.You can also check the gateway settings.

3.Check the semantic models settings.

 

4.The result is shown below.

 

Looking forward to your reply.

Best Regards

 

 

 

 

 

 

  • d4rren's avatar
    d4rren
    Frequent Visitor
    2 years ago

    thanks again v-jiewu-msft

     

    I applied settings suggested, however I did not have a 'cloud connection' to leanit set up.  I created a new cloud connection for leankit (so I had 2 connections, one web through my on premis gateway, and one cloud - both with the same settings) - very confusing.  I still cannot get this to work.

    Here are my datasource settings:

     

     

    and my on-premises data gateway settings


    any suggestions? I am still getting the same refresh error

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      1.You can also check the gateway version is up to date.

      2.Try to clear the brower's cache.

       

      Best Regards,

      Wisdom Wu