Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Scheduled daily refresh for free users

Hi   I have created a report in Power BI Desktop using the import option to get data (not direct query) from an Azure SQL server. I have a free license only as I want my users to only use free lice...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    Based on my test, if we only retrieve data from the Azure SQL database in Import mode and enable daily refresh, it doesn't require Pro license.

     

    To understand the difference between Power BI pro and free better, you need to know what's the pro content firstly. You can see not all data sources and refresh can be available to free users. If you share the dashboard with other users only have free Power BI features, your recipients just need a free Power BI license to view the content. See: Licensing requirements for sharing.

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

JozeM

 

It turns out I misunderstood our set up and I am actually pulling from an on premises SQL database, so it was working correctly and I have had to use a Pro license after all.

 

I did test with a basic excel workbook on my one drive however (before I got a pro license), and it allowed the daily refresh so not sure why it isn't working for you. Are you sure there isn't something else in your report that is requiring a pro license?

JozeM's avatar
JozeM
Frequent Visitor
9 years ago
No, definitely not. What I have is a .CMD file that uses SQLCMD to dump files to a .CSV file. It also puts a current time into another .CSV file. (I have also tried, using VBScript to convert these CSVs into a single .XLSX file, same result). Then I use = Csv.Document(Web.Contents("https://*******.sharepoint.com/personal/*******/Documents/*******.csv"),[Delimiter="#(tab)", Columns=16, Encoding=1250, QuoteStyle=QuoteStyle.None]) to import data. I publish PBIX file and resulted data source has no OneDrive Refresh option. And if i switch (regular) Data Refresh on, report becomes Pro. If I switch it off, it becomes Free.