Forum Discussion
Data Lake Gen2 Connector
I've tried connecting into our gen2 data lake with the new Power BI connector and get the error - "access to the resource is forbidden". I'm owner across the subscription, resource group, resource etc, etc. so surprised it sounds like a permissions issue. Colleagues have hit a similar error through different resources/tenants. Is this a known issue or is there a workaround?
7 Replies
Hi trisrobinson ,
In your scenario, I would suggest you opening a ticket at https://powerbi.microsoft.com/en-us/support/
Best Regards,
Teige
Unfortunately I can't say I know how I managed to fix it but managed to connect eventually. It could be because I work across multi-tenants and something was cached. I did raise a ticket but support were not much help. The only other thing you can try is adding yourself as a Blob Contributor against the resource but I'm not sure its this.
The only thing I did notice was that it took a very long time when it did connect as it seemed to scan the ENTIRE lake which was quite a surprise. It also doesn't provide you with what you expect to it - essentially a list of files in your lake, not the contents. It does provide the binaries for these but I assume you need to write a function around this to deconstruct, either way feels very much like a beta connector.
I guess I was expecting to be able to connect, select a bunch of files and then import them as tables..
The only thing I can say is you need the dfs end point since blob is not supported with gen2 just yet, I've no code since it was just a get data. Below was the output after the connector went through, as you can see lots of parquet support files.
