cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andykmwong Member
Member

Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

Dears,

 

With the succeed to change the SSRS Virtual Directory and Report Server URL after install the SSRS Technical Preview

 

 https://www.microsoft.com/en-us/download/details.aspx?id=54610

 

Everything is fine however encounter an error on Power BI reports upload to the SSRS Version 14.0.1.353 but the have only install the Power BI for SSRS already.

 

"We can’t open this Power BI Desktop report because it contains an unsupported data source connection or embedded data. This preview version supports only Power BI Desktop reports that connect live to SQL Server Analysis Services (on-premises). "

 

Anyone could help ?

 

Thanks 

Andy Wong

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

Hi @andykmwong,

 

>>"We can’t open this Power BI Desktop report because it contains an unsupported data source connection or embedded data. This preview version supports only Power BI Desktop reports that connect live to SQL Server Analysis Services (on-premises). "

Current this feature only support SSAS datasource.

 

>>I found that this preview only supports the Power BI Desktop connect to SQL Server Analysis Services Database but not to SQL Server Database.

SSAS connector not support "SQL Server Database", so you can't use this connector connect to sql server database.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

6 REPLIES 6
andykmwong Member
Member

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

01.JPG02.JPG03.JPG04.JPG05.JPG

 

andykmwong Member
Member

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

Dears,

 

I found that this preview only supports the Power BI Desktop connect to SQL Server Analysis Services Database but not to SQL Server Database.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analysis-services-tabular-data/

 

However, what security UID to grant to SQL Server ?

 

Thanks 

Andy Wong01.JPG02.JPG03.JPG04.JPG05.JPG

Community Support Team
Community Support Team

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

Hi @andykmwong,

 

>>"We can’t open this Power BI Desktop report because it contains an unsupported data source connection or embedded data. This preview version supports only Power BI Desktop reports that connect live to SQL Server Analysis Services (on-premises). "

Current this feature only support SSAS datasource.

 

>>I found that this preview only supports the Power BI Desktop connect to SQL Server Analysis Services Database but not to SQL Server Database.

SSAS connector not support "SQL Server Database", so you can't use this connector connect to sql server database.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

phongau New Member
New Member

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

 

This limitation of the May 2017 preview version seems to still exist in the June 2017 GA version of Power BI Report Server. I'm running the latest Power BI Desktop Version 2.47.4766.581 (June 2017) and Power BI Report Server Version 14.0.600.286 (June 2017). When trying to save as the Power BI report to Power BI Report Server, still getting the same error message. Can some one confirm if this limitation will be lifted in the future release?

 

"We can't publish this Power BI Desktop report because it contains an unsupported data source connection or embedded data. This preview version supports only Power BI Desktop reports that connect live to SQL Server Analysis Services (on-premises)."

 

Thanks.

pgroberman Frequent Visitor
Frequent Visitor

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

I have the same issue... will this restriction be lifted, and when? Thanks!

sbowman Frequent Visitor
Frequent Visitor

Re: Issue Encountered : Upload Power BI reports to SQL Server Reporting Services Error

I am having the same issue.  Can you not save a PBIX file with SQL Server Database data to Report Server??????  

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors