cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
barakb32 Regular Visitor
Regular Visitor

Power BI Dashboard - Refresh fails for Excel and pbix

Hello,

 

I have some issues/Questions:

 

1. A customer is implementing Office 365 with Power BI. What licensing would they need to have in order for Power BI for Office 365 to work with Excel Files? Would they need licenses also for SharePoint (in order to have a aplce to upload the Excel)? BTW. I understand that Power BI for Office 365 works only with Excel and not with pbix. Is that true?

 

2. When using Power BI Dashboard (not connected to Office 365), I try to create a report based on on-premise Excel but whatever I do I can't refresh it. I installed the Gateway and I see that it works, but...

 

a. Ideally, the report will be built with Power BI designer. I then upload the pbix file as a dataset and see the data, However, when trying to set credentials to the pbix file in order to refresh I get only the "windows" option. When clicking OK I get a message that the login failed.

 

b. Alternatively, I upload the Excel as-is as a dataset. Again, I see the data, but when coming to refresh I see the message: Cannot refresh data for this dataset because it gets data from sources that currently don't support refresh.

When clickin "Learn More" I get to https://support.powerbi.com/knowledgebase/articles/474669-refresh-data that says that Excel file can be refreshed.

 

Please help.

 

Regards,

Barak

4 REPLIES 4
alaeddin14 Regular Visitor
Regular Visitor

Re: Power BI Dashboard - Refresh fails for Excel and pbix

Hi @barakb32 ,

 

1. For Power BI for Office 365, you need O365 E3 + Power BI add-on, or O365 ProPlus + Power BI for O365 standalone. But of course, going with Power BI for Office 365 is NOT recommended as the user of this service will be transferd to the new Power BI.

 

2. For refreshing the reports, the Excel or pbix file has to be connected to a datasource (on-prem) through Power Query, then you configure the Gateway on the computer where the datasource is located, then upload the report to Power BI site. Of course you need to add your machine's Windows login credentials so Power BI will be able to access the data source on your machine to get the updated data when it refreshes your report.

 

Hope that helped,

 

Alaeddin

barakb32 Regular Visitor
Regular Visitor

Re: Power BI Dashboard - Refresh fails for Excel and pbix

Hi @alaeddin14,

 

Thanks for your reply.

 

So you say that any solution for Power BI for O365 won't stay as is but will be migrated to the new solution... That's important to know. Where do Microsoft communicate this information?

 

Regarding "adding the machine's Windows login" - how can I do that? I only get the "Windows" option without any place to type user and password?

 

Thanks,

Barak

alaeddin14 Regular Visitor
Regular Visitor

Re: Power BI Dashboard - Refresh fails for Excel and pbix

Hi @barakb32 

 

As for the transition, oyu may chech this article: https://www.microsoft.com/en-us/powerBI/licensing.aspx

 

Regarding the credentials, i think i you're right, i'll reinstall the gateway again and will double check.

 

Alaeddin

Highlighted
shrijay New Member
New Member

Re: Power BI Dashboard - Refresh fails for Excel and pbix

I am facing the same issue. Could you solve it?

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 293 members 3,331 guests
Please welcome our newest community members: