Hi,What I have suggested to people who want to use Excel for Power BI Dataset's is to use the Power BI Publisher for Excel.
The difference here is that it installs as an Excel Add-In, so it is always available.Then using this Add-In you can then sign into the Power BI Service and select which datasets you want to connect to.Any dataset in any workspace that you have access to, you will be able to connect through.https://powerbi.microsoft.com/en-us/excel-dashboard-publisher/With regards to the Log-In Window that you see, that would be due to the fact that Power BI is running on the underlying Microsoft Azure Platform, which does the authentication back to your Azure Active Directory to log you in correctly. The difference is when you are in the Power BI Service, it just masks it slightly differently.
Hi Richard,Your observation is indeed 100% correct.
When you refresh your Excel file it is simply loading the data that is stored in the Power BI Data model in the cloud.If you want to refresh your Power BI Data model, as you mentioned (Also correct), you have to do this with the On-Premise (Enterprise Gateway).And as a side note when a refresh is initiated data is always pushed from your On-Premise data sources to Power BI. And never the other way around.
Contact PUG | Code of Conduct
Site designed by Brightfind
Powered by Cobalt xRM and Higher Logic