when i try to open a Excel File i get following Error Message:
I found this issue in my environment. I turned out to be from a user dragging the Power BI Desktop icon onto the Windows Desktop as a Shortcut. I am guessing for whatever reason in doing so the app runs under different permission since Windows Store Apps have different permissions inside the directories it wasn't creating the cache folders inside the temp directory causing these errors.
Long story short, delete the desktop shortcut that was created and run it from the start menu. Otherwise, create the shortcut from the start menu intsead.
Thanks, Spicer. This is ONLY thing that worked for me so far. I was getting the same issues...followed a bunch of "solution" steps in other posts, but nothing worked. Then I uninstalled and reinstalled (both PowerBI and PowerBIGateway) like you suggested, and now it loads my new tables.
Anyone else having this problem? I upgraded my PowerBI Desktop to the May release and now I get the error when connecting to any table in my SQL Server database. Tried uninstalling the Desktop and reinstalling without success, nor does reverting to a previous version of the desktop release (March 2017). Any suggestions gratefully received.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!