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.
Why does this gateway id exist when I import a report .pbix file?
I'm attempting to update my sql credentials to be the service principal used to create the profile, workspace, and dataset. I'm using this gateway Id but my attempts to set the service principal as the sql login are failing.
Hi @mmccarver ,
If I understand correctly, you want to set the service principal as the credential of SQL data source. You can refer the following blog to get it:
- Add Service Principal as a user of the data source(s) in Data Gateway – this can be done in the Power BI service
- Add Service Principal as an Administrator of the Data Gateway – this can be done in the Power BI service
- Make Service Principal the owner of the dataset – this must be done via PowerShell
- Bind the dataset to the Data Gateway data source(s) – this must be done via PowerShell
Best Regards
Thank you for your reply. My task is to automate this process. We are building a multi tenant solution: "embed for customers" and each customer gets a profile, workspace, and a copy of reports. Each customer has a separate database.
After importing a copy of the base reports to the customer's workspace, I need to update something so that when the report is loaded, it connects to the correct customer database.
All the reports are direct query.
I was able to set up a VNET gateway and I have verified network connectivity to my azure sql instance. I just need to make each customer's report point to the correct database.
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.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |