Power BI Dataflows and fixing ‘Your Azure storage account must be in the same Azure Active Directory tenant as your Power BI tenant.’

I’m excited about Power BI dataflows, since I believe it’s a great way forward for companies to sort out the issue that nobody likes to talk about: cleaning data. I’m passionate about this topic since I believe in inheriting technical debt as much as I can, so I leave the organization’s technical debt in a better place than I found it. I’m taking the long view when I de

I tried to connect my Azure Data Lake gen 2 storage to Power BI, and I ran into this error message:

”Your Azure storage account must be in the same Azure Active Directory tenant as your Power BI tenant.’

I checked, and my Azure storage account was definitely in the same Azure Active Directory tenant as Power BI. So I was confused. What a pesky error! So I decided to investigate.

It turns out that I had missed a step when setting up the connectivity between Azure Data Lake gen 2 storage account and Power BI. I had missed assigning the Reader role to the Power BI service on the storage account.

Microsoft’s instructions are here and make sure you follow them to the letter. I missed a step because I rushed through it, and then spent time trying to figure it out, so it was my fault since I scrolled past a step. I’m recording this issue here in case anyone else gets this error message, and wonders what’s going on.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s