cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcodea Regular Visitor
Regular Visitor

Planview Ad-hoc Analysis OLAP Cubes with Power Bi Services

According to Planview documentation is it possible to connect cubes directly in Power BI Desktop, using SQL Server Analysis Service as datasource type.

 

Is it possible to use the same data source in Power Bi online Services?

 

Regards

 

1.png2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: Planview Ad-hoc Analysis OLAP Cubes with Power Bi Services

Hi @marcodea,

You create report using the data from SQL Server Analysis, then publish it to Power BI service. Then the dataset and report exist in Power BI service. In desktop, you can refresh the dataset, if you still want to refresh data in online service, you need to install data gateway (including On-premises date gateway and Personal gateway) if you have pro license or A free 60 Pro Trial license. Add SSAS as date resouce in Gateway. Then you can update the dataset in Power Bi service using gateway. Please review this blog, it describes gateway in details.

You can also create a scredule refresh to update the date automatically. More details, please review: Configuring scheduled refresh.

Best Regards,
Angelia

View solution in original post

3 REPLIES 3
Microsoft v-huizhn-msft
Microsoft

Re: Planview Ad-hoc Analysis OLAP Cubes with Power Bi Services

Hi @marcodea,

You create report using the data from SQL Server Analysis, then publish it to Power BI service. Then the dataset and report exist in Power BI service. In desktop, you can refresh the dataset, if you still want to refresh data in online service, you need to install data gateway (including On-premises date gateway and Personal gateway) if you have pro license or A free 60 Pro Trial license. Add SSAS as date resouce in Gateway. Then you can update the dataset in Power Bi service using gateway. Please review this blog, it describes gateway in details.

You can also create a scredule refresh to update the date automatically. More details, please review: Configuring scheduled refresh.

Best Regards,
Angelia

View solution in original post

marcodea Regular Visitor
Regular Visitor

Re: Planview Ad-hoc Analysis OLAP Cubes with Power Bi Services

Dear @v-huizhn-msft thanks for you replay.

 

Your reply is very clear. I'm already using a GW to refresh on premises data source, as excel files and Oracle database.

 

Your solution is effective also if my Planview server is on cloud? Is there any alternatives without the gateway?

Basically, in this scenario, Power Bi services and Planview are both cloud solution.

 

regards

Microsoft v-huizhn-msft
Microsoft

Re: Planview Ad-hoc Analysis OLAP Cubes with Power Bi Services

Hi @marcodea,

In Power BI service, please select "Get Date" on the left bottom, then connect SQL Server Analysis Services. Please review the article: SQL Server Analysis Services live data in Power BI.

Thanks,
Angelia

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)