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.
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,
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?
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.