multiple users multiple data sources

[dknox]

Hello Microsoft Community

I have two different Office accounts, one with PowerBI licence and one with OneDrive (different entities in my organization). Is there a way to link my OneNote source into PowerBI Desktop by sharing it? I cannot seem to find how to link the files in Desktop or online version.

Any help/insight is appreciated!

[v-juanli-msft]

Hi @dknox

It currently doesn't support to get data stored in onenote with power bi.

please review and vote this feature request. If Power BI add it, the idea status will be changed completed. And please look you eye on the blog

(Additionally, As for embedding powerbi in OneNotes, OneNote now supports live embedded Power BI reports)

Best Regards

Maggie

[dknox]

Hi Maggie,

My appologies but I had a typo in my request that may change your response. I meant to write OneDrive, not OneNote and have edited my question accordingly. I am looking to share files in OneDrive and link into another Microsoft Accounts's Desktop. Any additional advice would be greatly appreciated.

[v-juanli-msft]

Hi @dknox

As tested, when you connect to OneDrive with Power BI, you could only connect to OneDrive which use your own account.

Refernce:

Connect to OneDrive for Bussiness with Power BI Desktop

Connect to OneDrive for personal with Power BI Service

Best Regards

Maggie

[Anonymous]

The Power BI license account needs to be the user logged into Power BI (both Desktop and Service) in order to publish your report.

Data sources need credentials, but these can be different to the credentials of the user writing the report.

[dknox]

Hello Ross,

I just realized that I put OneNote but meant OneDrive. Can you please ellaborate on how I can use different credentials to link a file into another PowerBI Desktop account? I would like to be able to share files in OneDrive for automatic updating into PowerBI if at all possible.

[Anonymous]

@dknox each one drive has a unique file location.  If you want to change which onedrive a file source location is, you would have to make use of Parameters within the Edit Queries section, or some other method of dynamically changing the source URL.  You would have to then enter the credentials into the "Edit Credentials" section within the dataset options, easiest found via the "Schedule Refresh" menu item.

I'm not even 100% sure it will let you do that, but if it does, that would be what would be needed.