Auto Refresh not working on web app

Hi carlito

I would think that it could possibly be that currently even though you are connecting to Google Sheets, it could be the cause of the auto refresh not working.

Also I do know that in order to refresh the data if you are using it via a Web Connector that it would require a Gateway to be installed (As far as I am aware).

As well as currently if you are using the On-Premise Data Gateway, whilst you can have different sources from on-premise and cloud, if there are any applied steps in your Query Editor then the On-Premise Data Gateway will not be able to refresh the data. This is being worked on as far as I know, but has not been released yet.

In order to troubleshoot, I would suggest first creating the report with just the Google Analytics, upload and see if that will refresh. Next try the Google Sheets, and test. And then finally the Facebook Web Connector. If it fails after an upload then remove the one you just added to see which one is causing it to fail.

With regards to your dataset question, when you upload a PBIX file, there are 2 components on upload. One is the underlying dataset which stores all your information (if you used the Import Mode). As well as your reports you created in Power BI Desktop. 

Now when you are in the Power BI Service and you click on the Dataset, by default it will open a blank report canvas. Which will then allow you to create reports in the Power BI Web Service. And that is why it always appears to be blank.