Forum Discussion
Workspace, semantic model, report, users and dataset lifecycle management
palamanb_Risk appriciated to help you. Here are the outlined steps to do the same.
1) Copy the attached .MEZ file on C:\Users\MagnusMinds\Documents\Power BI Desktop\Custom Connectors folder on your machine.
2) Open power bi desktop and do this setting and restart the power bi. (This is a setting to use the custom connectors)
3) Open power bi and clcik get data -> search for custom or any relevent text
4) After click it ask you to allow third party connectors.
5) It list the available API endpoint in a form of function you can use whatever you need
6) Load data and build the dahboard/report as your own. Then below are the steps for the gateway setup and refresh same report on the service on schdule basis.
Add the custom connector folder here in the connectors section.
create the gateway on the service using this connector use it in the semantic model as well.
I hope this helps! If this resolves your issue, please mark this as the Accepted Solution to help others.
Note: Try to do in the hierarchy like (workspace\group -> Dataset -> Report etc....) As the respective function need the parent as a parameter.
Hi palamanb_Risk,
Do you have any updates on this? If you are able to load the data or not!
Hi Lodha_Jaydeep , I have tried this way and thank you for your time in helping me . Unfortunetly I am not able to load the data. Insted I run a power shell script and I am able to extract the information regarding the users of all workspaces in my organization along with the roles as well.
Thansk a lot for putting efforts in help me once again.
I will keep in touch with you moving forward if the method what you have suggest can help in a better way.
I agree , running the powershell script is more static and manual. I would apriciate if the suggestion help me in getting the data load to a power bi reprot.
Hi palamanb_Risk,
Thank you for your kind words. It is unusual that the recommended method isn't working in your environment.
To help me troubleshoot further, could you provide a breakdown or screenshots / screen recording of the specific steps you are taking when using the connector?
It is great to hear that you've successfully retrieved the data via PowerShell. There are several robust ways to integrate that data into Power BI; here are the most effective methods:
Option 1: SQL Server Integration (Recommended): Use your PowerShell scripts to ingest the data into SQL Server tables. This is the most scalable approach, as it allows for seamless scheduled refreshes in the Power BI Service via an On-Premises Data Gateway.
Option 2: Flat File Staging: Export the data to a shared location, such as Azure Blob Storage or SharePoint etc..., as a CSV file and connect Power BI to that source.
I recommend the first approach for better performance and easier refresh management. Please let me know if you have any questions!
Let me share the steps that I have followed.
Will get back to you on Monday.
ThanksLet me share the steps that I have followed.
Will get back to you on Monday.
ThanksHi palamanb_Risk ,
Could you please confirm if the suggested approach helped resolve your issue. Your confirmation would also help others facing similar scenarios.
Thank you.
Hi palamanb_Risk,
Hope you are doing good! Please feel free to reach out if you still have any issues while laoding or dump the data. If you provide some steps with the connector issue in the power bi. It will be good enough.
Hi palamanb_Risk ,
Thank you for posting your query in the Microsoft Fabric Community Forum and thanks to Lodha_Jaydeep ,Max_701 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you.
