This problem has been bothering me for a long time. When I use the Analyze in Excel feature in Power BI and open the downloaded files in Excel, I get the following error.
I am sure that it is set up correctly in Power BI. This problem appears suddenly and exists for all reports. My excel version is 2016.
And when I want to connect directly from Excel to Power BI, I can't find the Power BI data source and I don't know if I have wrong somewhere.
I didn't find a solution online and I hope someone can help me, thanks in advance.