Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This started today. I've opened a couple Power BI desktop files that include connections to our SQL server and Excel files on SharePoint. When I try to refresh, the data source settings for SharePoint have flipped to Anonymous and so they fail - it says "access is forbidden." I try to clear permissions or change the data source settings to organizational, it says I'm not signed in (but I am) and when I click on my user id, it says taking you to your organizational sign-in page, and then I'm taken to a plain white screen where it hangs up. I now cannot refresh any files with SharePoint data sets as it says "access is forbidden" because permissions appear flipped to anonymous and I cannot set them to organizational with any success. This is so frustrating.
Interestingly, I published one of the reports to powerbi.com and scheduled a refresh with the enterprise gateway and "refresh now" works!
The only thing I did today that I can think of that may have screwed something up is trying to install a MySQL connector - which was for a different SQL server that I cannot get the refresh working for either, but this is another story. I've uninstalled the MySQL connector, and again, I don't know if this has anything to do with it or not, but thought I'd mention it.
Here's the screen that comes up after I click on my organizational account ID. It says taking you to your organizational sign-in page and then it just hangs here and does nothing, even if I try to refresh.
I even upgraded to the March edition of Power BI and still the same problem. Please help! Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.