cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

5 REPLIES 5
v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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=disabl...

 

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.


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).

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

mee too, i have the latest Power BI Desktop (August 2017 Preview).

 

I was able to connect to excel, but when I attempt to save in Report Server it show this error.

 

August Update.JPG


@rommel20 wrote:

mee too, i have the latest Power BI Desktop (August 2017 Preview).

 

I was able to connect to excel, but when I attempt to save in Report Server it show this error.

 

You need to have the August Preview of Power BI Report Server too, not just the Desktop. If you're still running the June GA release of PBI RS then it's not going to work even with the August desktop.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.