Forum Discussion

spock1984's avatar
spock1984
Frequent Visitor
6 years ago

Excel published to service - cannot refresh

Dear community, I have a problem with PBI Service. Here is the situation: 1) I set up a PBI report in Desktop, published it to Premium workspace 2) I used "Analyze in Excel" function - created a r...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi spock1984 ,

 

After using "Analyze in excel "function,you can save this Power BI dataset connected workbook just like any other workbook. However, you cannot publish or import the workbook back into Power BI because you can only publish or import workbooks into Power BI that have data in tables, or that have a data model. Since the new workbook simply has a connection to the dataset in Power BI, publishing or importing it into Power BI would be going in circles!

 

My suggestion for you is to download the .pbix file from service then modify it in desktop and save it as another report.

 

Here is a reference about "analyze in Excel":

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!