Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I posted this on Forums > Desktop, but I believe here (Forums > Service) is the right place as I'm talking about powerbi.com.
Let's say I have the following case:
I uploaded Sales Analysis.pbix to powerbi.com using the "Publish" link from PBI Desktop and now I have a "Sales Analysis" report and datasets. I have the following questions regarding powerbi.com functionalities:
When I opened Sales Analysis.pbix using PBI Desktop locally on my machine I could simply hit "Refresh" and it would use my credentials to get data from wherever source I've set. I always had access to the data in its entirety, since PBI Desktop would fetch it from the source. Now that Sales Analysis is inside powerbi.com and not locally anymore, will I be able to do the same, aka, see and interact with the complete data and not just "samples" of it? If positive, how powerbi.com does that? I believe it's not running inside my enterprise network, so how come it can get the data from my SQL Server and files from the enterprise network?
If, for example, I create another tab with some views inside my Report on LOCAL Sales Analysis.pbix and save, would it update my Sales Analysis inside powerbi.com? Is the local Sales Analysis.pbix linked in any way with the Sales Analysis inside powerbi.com?
Solved! Go to Solution.
In short, Power BI Service uses Gateway to "find" the on-premise machine which hosts those files and do refresh. You need to install either Personal or On-premise Gateway on your on-premise machine. It will send the request to Azure Service Bus.
For more details, please refer to:
On-premises data gateway in-depth
This is for "data refresh" only. You .pbix file is not linked with the report you published onto Power BI Service. If you have some changes in your report, you have to republish it.
Regards,
In short, Power BI Service uses Gateway to "find" the on-premise machine which hosts those files and do refresh. You need to install either Personal or On-premise Gateway on your on-premise machine. It will send the request to Azure Service Bus.
For more details, please refer to:
On-premises data gateway in-depth
This is for "data refresh" only. You .pbix file is not linked with the report you published onto Power BI Service. If you have some changes in your report, you have to republish it.
Regards,