Forum Discussion

andykmwong's avatar
andykmwong
Helper III
9 years ago
Solved

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   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

phongau's avatar
phongau
New Member
9 years ago

 

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's avatar
pgroberman
Regular Visitor
9 years ago

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