Forum Discussion
Secure connection to Data source
CarlaGh , refer my video on dataflow, dataset
Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA
Refer series of document - https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
When you publish a report using dataflow or dataset. Open your workspace. There on the dataset click on three dots and go to setting. There you will have an option for datasource credentials
CarlaGh , For that you need to create a dataflow and use that. But that will not be a direct query, as dataflow imports data. The database needs to be a cloud database.
In any case, You need to provide credentials in power bi services. When you use desktop file and publish you have to give that under datasource setting.
I can import and schedule refreshes.
Can you provide me please with more documentation that I can refer to ?
Also, I have Azure SQL DB and Blob storage that I am connected to .
Thanks!
CarlaGh , refer my video on dataflow, dataset
Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA
Refer series of document - https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
When you publish a report using dataflow or dataset. Open your workspace. There on the dataset click on three dots and go to setting. There you will have an option for datasource credentials