Forum Discussion
Unable to connect to Power BI Datasets from Excel
Community SupportHi, petesuen
Can you connect normally after closing this error?
I try to reproduce your scene, it works normally in my version. You can try to upgrade the excel version of one machine.
My version:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi Janey
"Closing" the error does nothing. The exact same error occurs if I "Insert" ➡ "PivotTable" ➡ "From Power BI (xxxx)"
I'll ask IT if they can update Excel, but it seems to tell me I'm already on the latest version (Semi Annual Enterprise Channel)
Cheers
Peter
- v-janeyg-msft
Hi, petesuen
Sorry, I can't reproduce your scene in my computer. Do you use a pro license?
There is also a function on the service called ‘Analyze in Excel’, can you use it?
Please refer:
Analyze in Excel for Power BI - Power BI | Microsoft Docs
Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Everyone in our company should have the Pro license.
It does work while clicking on "Analyze in Excel" on a report from app.powerbi.com
Unfortunately that's an extra step that's unlikely to appease the crowd.
I have been in touch with Microsoft so I'll report back if I have anything new.
- v-janeyg-msft