Forum Discussion
Using a Dataflow connector with different credentials
Hi everyone, so Microsoft support have come back and have basically said that in order to do this, I either need to use an on-prem gateway .... for an Azure source... I'm not sure they fully understood the ticket, but ok.
OR use the Dataflow Gen 2 instead of Gen 1. I don't have a license for the Gen 2, so that isn't going to work for me and I don't know if I'll be able to get the company to pay for it.
I have been looking at the composite models and I may have a way around it with multiple semantic models - one model for each tenant, and then combining those potentially. It won't be a 'clean' way of doing it, but I think it might just work - because I can set the credentials for each semantic model using the method GilbertQ mentioned above - creating the creds first.
Hi zantarel ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Poojara_D12 and GilbertQ for the prompt response.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
Hi
So far nothing has worked. I got pretty close with @GilbertQ idea - but the only way I could do that would be to create a semantic model for each tenant, and then probably write a powerAutomate flow to scrape that data into something a dataflow could consume in order to get to the end goal of having all subscriptions and tenants in one semantic model ... Of course, if we could combine different semantic models (which is on the roadmap) that would remove the need for PowerAutomate to scrape the data. As it is, I am investigating using Fabric within the organisation and have a ticket open with Support about this. Will update when I hear anything useful.
Hi zantarel ,
Thank you for the update, please let us know if you have any further queries, we are happy to address.
Thank you!!
Gilbert's proposal should work out if you use the web connector instead of the native ARG connector.
Create for every tenant a connection and choose those in your dataflow.
That's how I would try to proceedWhat do you mean by the 'web connector'?
