Forum Discussion

mozuliov's avatar
mozuliov
New Member
8 years ago

cannot import Excel file to Power BI

I cannot import Excel file saved on OneDrive to Power BI dataset. It has worked before just fine. I even tried to import the ones I had previously imported and it did not work any more. Need help: ...
Need Help
mozuliov's avatar
mozuliov
New Member
8 years ago

I was able to import this Excel book (containing Power Pivot model) from local file to Power BI Desktop. I also can connect from Power BI Desktop to certain tabs of this Excel book published on OneDrive.

However, I still cannot create a dataset on Power BI from this Excel book being either being saved on OneDrive or from Local File.

Also, I cannot create a dataset from Excel files (containing Power Pivot models) I have previousely was able to...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    mozuliov,

    Have you enabled multi-factor authentication(MFA ) in your scenario recently?

    Regards,
    Lydia

    • mozuliov's avatar
      mozuliov
      New Member
      8 years ago

      I have not. Probably my admins did - I will ask them. 

      Another news: starting today I cannot refresh already published models that connected to OneDrive! Last Refresh was on Apr 17th - still with warning, but it was refreshing. Today - nothing....