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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi d4rren ,

If I understand correctly, the issue is that you failed to refresh report on the service. Please try the following methods and check if they can solve your problem:

1.Go to the semantic model settings, ensure the privacy levels for all data sources are set consistently.

2.Check the refresh history of the semantic model in the Power BI Service to see if there are any additional details about the failure.

3.Verify the credentials for the excel, web source and SQL Server are correctly entered and have the necessary permissions to access the data.

 

4.You should also turn on the Data connections.

Looking forward to your reply.

Best Regards,

Wisdom Wu

 

 

  • 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