Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0

Unable to publish pbix to Power BI - Impala source- 5MB

Submitted by Anonymous on ‎04-16-2017 05:14 PM

Hi,

 

I m using Impala for data source and was able to connect and import data.

However, when I try to publish the PBIX, its failing.

 

Data size is only 5 MB and hence shouldn't be a problem.

 

I suspect this to be a firewall/ proxy issue as I m unable to publish for other sources as well from the same box.

Are there any ports that need to be opened in order to facilitate publish to Power BI?

 

Thanks in advance.

 

 

 

 

 

 

Status: Delivered
See more ideas labeled with:
8 Comments (8 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎04-17-2017 11:35 PM

@Anonymous

 

What is the error message when the publish failed? Can you sign into Power BI Service properly in your network? If yes, you can try to publish your PBIX file through Get Data - Files - Local File - Select your PBIX file in Power BI Service.

 

Best Regards,
Herbert

 

 

Vicky_Song
Impactful Individual
Impactful Individual
‎04-17-2017 11:36 PM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎04-18-2017 07:14 AM

Thanks for the reply @v-haibl-msft @Vicky_Song

Yes. I m able to sign-in into Power BI Service.

I replicated this report in import mode and managed to publish it successfully. Its failing only in Direct Query.

Its a simple report with one bar chart visual to display Product vs Sum of Order Value (Default Summarization). The error is as shown below in the snapshot - "(500) Internal Server Error."

 

Publish_error.jpg

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎04-18-2017 09:26 PM

@Anonymous

 

Have you tried to publish your PBIX file through Get Data - Files - Local File - Select your PBIX file in Power BI Service?

 

Best Regards,
Herbert

Anonymous
Not applicable
‎04-19-2017 12:36 AM

Yes. The report has only 1 table ... and there are no measures/ Calculated columns that have been created yet.

Do I need to configure on-premises gateway for Direct Query/ Live connection to work with Impala Data Source?

 

The error snapshot is provided below:

 

culdn't load visual.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎04-21-2017 11:14 PM

@Anonymous

 

Impala is not supported yet for refresh. Please refer to 'Considerations and Limitations' section of https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-impala/

 

Best Regards,
Herbert

 

Vicky_Song
Impactful Individual
Impactful Individual
‎04-21-2017 11:15 PM
Status changed to: Delivered
 
Anonymous
Not applicable
‎04-23-2017 07:06 AM

Thanks for clarifying.

We cannot publish reports in Direct Query as data refresh is not supported.

As per the email I received from Microsoft support, data refresh should be expected by end of Summer 2017.

 

 

 

Idea Statuses