Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You cannot use anonymous auth for that. Requires at least AAD Auth.
Recommendation is to use the custom connector.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.