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
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.
