Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful 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
masplin's avatar
masplin
Icon for Impactful Individual rankImpactful 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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Impactful Individual rankImpactful 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 

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

      Hi masplin,

       

      There is a menu "View Content pack" in the gear button. You can view all the content pack. If you select "Edit", you can see what are inside them.

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Best Regards!

      Dale