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.