Forum Discussion

masplin's avatar
masplin
Impactful Individual
8 years ago

Spreadsheet built using Power BI Publisher stopped working

I just updated a desktop model adding in a new query and a single new calcauted column on an exisitng table. I saved and published.  i opened the excel workbook that is linked and clicked refresh dat...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

masplin,

 

Hi Mike,

 

I tested it following your description. But I didn't find any issues. Please check these items below.

1. One workbook can have many connections. Were you in the right worksheet?

2. Did you show them all?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3. What is the type of the new query? Import or Live? 

4. Do you keep the login status?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

  • masplin's avatar
    masplin
    Impactful Individual
    8 years ago

    Hi Dale

     

    The issue is an exisitng sheet that was refreshing fine a few weeks ago now will not refresh due to the error message above.

     

    However if I click on Power BI/ Connect to Data I can create a new report no problem with the most current measures that have bene published.  So the issue seems to be with reports created previously.  It just ownt let me or anyone also in my company make the conenction to refresh.  I assume thisis caused by somne kind of update that has broken the link. I tried uninstalling and reinstalling the latest Publisher, but same issue

     

    It appears I coudl recreate every sngle report and it wil lwork, but that seems like the wrong solution.  

     

    If I do as you put below it says I am connected under the email address biadmin, which is the owner of the content Pack. however on refresh it just keeps asking me to login. like this. it asked a dozen times before you can exit. 

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi masplin,

       

      I just can't reproduce it. Please check these items below.

      1. What is the version of your Excel?

      2. Did you change the authorizations of the content pack when you updated it?

      3. Make a copy of your workbook, then try to delete the reports one by one to find out if any connections are the cause. I can't help you with this because of the permissions. OR, refresh the reports one by one. 

       

      Best Regards!

      Dale

      • masplin's avatar
        masplin
        Impactful Individual
        8 years ago

        Hi Dale

         

        So I simply recreated everythnig from scratch it all seems to be wokring fine. Same workbook, same content pack just chose the conenct to data and remade the reports.

         

        It's like the connection behind the exisitng reports just got corrupted or broken.  Is there any way you can see what content pack is conencted to a particualr report?

         

        Thnaks

        Mike