Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Non-analysis services data source connection to power bi and publish to power bi report server

Hi

 

how to connect non - analysis services data sources (excel, csv etc..) connect to power bi desktop and publish to power bi report server.

 

when i tried to connect in august 2017 preview version. It is throwing error. How to resolve it.

 

Thanks

sreenivasa

Need Help

5 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Anonymous,

     

    Did you connect to non - analysis services data sources in desktop successfully, while got error when you attempt to publish to report server? What is the error message? And please make sure you typed into correct Power BI Report Server URL.

     

    Regards,
    Yuliana Gu

    • intrasight's avatar
      intrasight
      Icon for Helper IV rankHelper IV
      9 years ago

      I'm wanting to follow up on this. Are you saying that other data sources should work? My reading of the documentation is that only SSAS currently is supported.

       

      https://powerbi.microsoft.com/en-us/documentation/reportserver-quickstart-powerbi-report/?cdn=disable

       

      Step 2: Select a data source

      Currently, the only data source supported with Power BI Report Server is a live connection to a SQL Server Analysis Services (SSAS)tabular model or multidimensional cube. More data sources will be added in future releases.

      • otravers's avatar
        otravers
        Icon for Community Champion rankCommunity Champion
        9 years ago

        Currently, the only data source supported with Power BI Report Server is a live connection to a SQL Server Analysis Services (SSAS)tabular model or multidimensional cube. More data sources will be added in future releases.

         

        The August Preview supports other sources, I'm currently using it with regular SQL (i.e. not SSAS).