Forum Discussion

aclifton's avatar
aclifton
Frequent Visitor
3 years ago

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 a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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. 

aclifton's avatar
aclifton
Frequent Visitor
3 years ago

Hi Neeko,

 

Currently, we do not have this data in a SQL server. It is in a cloud based data hub called ServiceChannel (servicechannel.com). We can export excel sheets from this website, but we want to try to directly connect it to Power BI so we can make reports with the data in there.

 

The only way to get the data in a spreadsheet formula seems to be by exporting it into an excel sheet, and I have to login with my user credentials before I can see anything. Is there something in the Get Data tab that I can use to make this possible?