Refresh of files from OneDrive for Business after switch to 2-factor authentication

[ailon]

I have a bunch of datasets from ODB that I added months or years ago, and then I switched 2-factor authentication on my O365 account. Now I have exclamation marks on all of these datasets claiming that it can't refresh from OneDrive for Business. I can add new datasets just fine, so it's not like it can't access my ODB in general, but it seems like something needs to be updated to handle datasets that were added before the 2FA switch. I can't find that something, though.

What am I missing?

Thank you!

Alan.

[Eric_Zhang]

---

@ailon wrote:

I have a bunch of datasets from ODB that I added months or years ago, and then I switched 2-factor authentication on my O365 account. Now I have exclamation marks on all of these datasets claiming that it can't refresh from OneDrive for Business. I can add new datasets just fine, so it's not like it can't access my ODB in general, but it seems like something needs to be updated to handle datasets that were added before the 2FA switch. I can't find that something, though.

What am I missing?

Thank you!

Alan.

---

@ailon

Did you add the data via "get data"->"other"->"web" in Power BI Desktop? Could you try to update the datesets credential in Power BI Service?

[ailon]

Hi @Eric_Zhang

The problem is not with data sources in the dataset (those refresh fine) but in the actual pbix files. All the data in my reports in the Power BI service is successfully refreshed every day (most coming from SQL Azure), but if I change something in my PBIX (add or change a report or something) it won't be picked up.

Just today I got a bunch of emails like "[filename].pbix OneDrive refresh disabled" for all my files in ODB.

Theoretically I could probably re-add these files and it will work, but I'll lose all of my Dashboard this way (as far as I undrestand) so I would really love to avoid that.

Alan.