Forum Discussion
Helper I2 sources de donnes diffrentes
Of course, a dataset can have date sources from local and cloud. When there is a mixed data source, you need to check whether this setting of the gateway is turned on in pbi service >>manage gateways. And data sources on the cloud need to enter credentials.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ JaneyHi, PIERRO1234
The sql data source can't be uploaded to the cloud, and If your computers and accounts are not under the same organization and domain,it will be hard to do. Do you share an account?
If the organization is not involved, the gateway can be installed in client. It is refreshed by him, Refresh by himself, but you need to help him configure it. And you need to upload a sql data source pbix on his computer, and then connect to the pbi dataset on your own desktop, and create the report yourself, then upload it to the service, and finally use the same data source.
Best Regards,
Community Support Team _ Janey
Helper IBonjour Janey,
Je vous remercie pour votre réponse tres claire.
J'ai fait cela car :
- La premiere source de données est une base SQL chez un client
- La deuxième source de données est un fichier excel que je dois modifier chaque mois à mon bureau
Donc, si je mets le fichier excel sur mon drive ofice, est ce que je peux avoir un jeu de données avec les 2 sources : le source de données SQL chez le client et le fichier excel sur mon drive?
Ma question est claire?
Merci.
Community Support
Of course, a dataset can have date sources from local and cloud. When there is a mixed data source, you need to check whether this setting of the gateway is turned on in pbi service >>manage gateways. And data sources on the cloud need to enter credentials.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey