Forum Discussion
Mixed Mode And Rest Api
Hello everyone,
I have two problems to solve and kindly ask for your help.
I have a model consisting of 3 data sources:
- mysql (import mode)
- postgresql (Direct Query mode)
- Api Rest to retrieve information on data refresh
Now! My first problem is mixed mode mapping. I have added the Postegresql and Mysql connection on the gateway and everything works. But when I go to set the gateway on the report connection it gives me the following error
I can't map to data sources.
The second problem is how to map the rest api queries.
This is:
https://api.powerbi.com/v1.0/myorg/datasets/.......id......../refreshes
Can anyone explain to me why?
Can't I set mixed mode on the same Gateway?
I state that the rest Api are not bothering because I tried to remove them and they do not map anyway.
On the other hand, if I publish the report with single connections, everything works.
Thanks everyone for the help
You cannot use anonymous auth for that. Requires at least AAD Auth.
Recommendation is to use the custom connector.
3 Replies
When you mix/merge on-premise and cloud data sources all data sources including the cloud data sources must be declared in the gateway. you also need to specifically tell the gateway that it can be used to refresh cloud data sources.
Hi lbendlin thanks for the reply,
I want to add https://api.powerbi.com/v1.0/myorg/datasets/reste as a data source but with anonymous connection I cannot update the dataset because it tells me that the credentials are not correct.
My problem is that on Power Bi Desktop I am able to use the connection.You cannot use anonymous auth for that. Requires at least AAD Auth.
Recommendation is to use the custom connector.
