Forum Discussion
Connect Data from Service Channel
Hi all,
I am looking for a way to connect data from the Service Channel web server to a Power BI file, or to create it as a data source in the Power BI web server. Service Channel is not listed as an option under the online services tab for Get Data, but I know it has to be possible. Any help would be appreciated, thanks!
5 Replies
Hi aclifton ,
What is your service channel? Please check the document to check if the data source you want to connect to is supported, if not ,you can post your idea to Ideas .
https://ideas.powerbi.com/ideas/
If your data source is web, refer to it :
-
In the Power BI Desktop Home ribbon tab, drop down the arrow next to Get Data, and then select Web.
- In the From Web dialog, paste the URL into the URL text box, and then select OK.
Please refer to the following document for more information.
Power BI Connections | List of Top 6 Data Connection Source Categories (wallstreetmojo.com)
Use Power BI Desktop to connect with your Project data - Microsoft Support
How to connect Power-BI with multiple web data sources or URLs | by Braulio Berlanga | Medium
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
Thanks for your response.
Service Channel is a web server that my company uses as a portal to show the data for Work Orders to our clients. The data is updated daily and we want to make a live connection to Power BI and be able to have the data that is in service channel in a Power BI document.
I tried doing it through the Web section under Get Data, but this does not seem to work, since we have to login with our credentials to service channel, and the data isnt shown in a spreadsheet format. The data can be exported from service channel into a spreadsheet, however, we want a live connection. Do you have any ideas? Any more help would be appreciated. Thanks!
Hi aclifton ,
You can import data into a SQL Server Analysis Services tabular model or SSAS MD database and use desktop for a live connection.
Please refer to the following document for more information.
Connect Live Power BI to SSAS Multidimensional (biinsight.com)
All About Power BI LIVE Connection Simplified 101 - Learn | Hevo (hevodata.com)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
