![power bi desktop scheduled refresh power bi desktop scheduled refresh](https://www.wisdomaxis.com/technology/software/powerbi/images/power-bi-automatic-refresh-configuration-1.jpg)
- Power bi desktop scheduled refresh update#
- Power bi desktop scheduled refresh manual#
- Power bi desktop scheduled refresh password#
Connection Type is the way that the connection is created to the data source. Apparently, Power BI supports hundreds of data source types. Connection Type is not Data Source TypeĬonnection type doesn’t mean the data source type. You will learn briefly how Power BI stores data into xVelociy in-memory engine, and what are pros and cons of this method in detail. In this section, we are going to cover everything about Import Data or Scheduled Refresh type of connection.
![power bi desktop scheduled refresh power bi desktop scheduled refresh](https://docs.microsoft.com/en-us/power-bi/report-server/media/configure-scheduled-refresh/manage-power-bi-report.png)
Yes, I think the schedule refresh options refer to the Azure SQL Database and not to the OneDrive spreadsheet as you say, but somehow both data sources get refreshed.Power BI is one of the BI tools in the market that supports more than one type of connection.
Power bi desktop scheduled refresh manual#
I can also trigger manual refreshes and the work the same. Power BI Service is giving me the option of scheduling refreshes by entering the time for each refresh in a section called Schedule Refresh and when a refresh time is due, both the Azure DB and the Excel spreadsheet refresh. I didn’t have to configure my credentials for neither the Azure connection not the OneDrive for Business connection as Power BI Service marked them as OK in the Data Source config section.
![power bi desktop scheduled refresh power bi desktop scheduled refresh](https://i.ytimg.com/vi/pacBkMqMjDQ/maxresdefault.jpg)
Then I I publish to Power BI Service, it seems that it recognizes that the Azure SQL Database is good for Direct Connection and somehow Power BI Service connects to Azure in this way because everything is working perfectly now and I do not have a gateway installed. For the Excel worksheet in OneDrive for Business, I connect to it entering the URL just as you describe above. I was able to make it work in this way: In Power BI Desktop I connect to the Azure SQL Database not with the Direct Connection option (I was previously using this option) selected but with the Import option selected. Hi Gilbert, thanks for your prompt response. Sorry for the long message, I’ve tried to be as clear as I can in the hope that you could advice about what could possibly be wring with what I’ve done. I can’t make it refresh manually and it doesn’t refresh under a schedule with by the way I can’t see any schedule options for it under Schedule Cache section in the Data Sources configuration section in Power BI Service. The problem is that the SQL database seems to be refreshing well, both manually and under a schedule every one hour, but the Web data source doesn’t. I’ve updated both credentials as Basic and “Organizational” privacy for the SQL database and as oauth and “Organizational” privacy for the Web data source so the match with what I did in Power BI Desktop.
Power bi desktop scheduled refresh update#
I have gone to the data source configuration and under the Credential of Data Origin I can see update options to update credentials for both, the SQL Database and a “Web” data source. Then I published to the Power BI Service and I can see that I have only one data source listed (which I assume encompassed both of my data sources ¿?). Whenever I refresh the information in Power BI Desktop, everything works perfectly.
Power bi desktop scheduled refresh password#
In Power BI Desktop, I’ve configured access to the OneDrive for Business spreadsheet with my organization account and a privacy level of “Organizational” (because Power BI Desktop does not let me choose “None”), I’ve configured access to the Azure SQL Database using “Basic” (user name and password for the SQL Database) and privacy level of “Organizational” following your advise above. In other words, I have a very similar scenario as Arun’s above, but my two data sources are in the cloud so I am not using a personal or enterprise gateway. I’ve been struggling for day with the same scenario you describe in this post, but with the addition that in my Power BI Desktop dataset, besides the Excel file in OneDrive for Business, I have another data source which is an Azure SQL Database. Hi Gilbert, I just found this post on your blog and read it very carefully.