Forum Discussion

Maradh's avatar
Maradh
Icon for Helper I rankHelper I
6 years ago
Solved

Create authorizations for data source (OneDrive Enterprise) manually

Hi, I was wondering if there is a way to creates authorizations for data source manually (im using OneDrive Enterprise for my project). I create a table in power query that generate for each ro...
Need Help
  • Maradh's avatar
    Maradh
    6 years ago

    Ok, the way the system to load data work is pretty awful honnestly...

    I needed to delete all my previous authorizations with OneDrive in my list (like a reset) before retrying to load them the same way I did since the beginning.

    This way, Power BI ask me again for me to connect with my professional account and then create the autorizations for my new OneDrive files.

    What is weird is that, previously, I was already connected with my professional account for all other autorizations but Power BI didn't use or recognize it and directly told me i couldn't acces to the data source because it was forbidden.

    This obviously need to be fix in my opinion

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello Maradh ,

 

the data source setting you are showing in your screenshot is to set if a data source is "official", "organisation" or "private".

This settings are needed for the Firewall-function to work properly. This setting is basically all about passing data from one datasource to another (table of Excel to WEB-Api etc.). And if a datasource is set to private and passed data to a official data source the query won't be executed.


If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy