Unable to Publish Excel workbook to Power BI service workpsace

[kumarp]

Hi Team,

Can any one help me on below issue:

I have done connection with SQL DB from Excel and when I am trying to publish Excel workbook to service I am gettting below error after selecting upload option.

Note : All accounts are connected with same email id

Error:

[kumarp]

@Anonymous,

@v-lili6-msft Please can you help me on above issue.

 

[GilbertQ]

Hi @kumarp 

As far as I know the Excel workbook will not be able to still connect back to the SQL Server from the Power BI Service and that is why it is failing. The workbook can show what you have in you spreadsheet but will not interact. That is my experience.

[kumarp]

@GilbertQ Thanks for your reply. Is there any way to resolve this. I am connecting to SQL DB using excel workbook with windows authentication and refreshing the data without any error. but while publishing into power bi service gettting error.

[GilbertQ]

Hi @kumarp 

As far as I am aware you cannot refresh an Excel workbook in the Power BI Service.