Forum Discussion

Qbota's avatar
Qbota
New Member
10 years ago

Refreshing with PowerBI Free user

I'm a bit confused because of licensing of PowerBI and Personal Gateway.   I have MSSQL Express with some data. I have PowerBI Desktop with some reports. I have account on app.powerbi.com, reports ...
Need Help
mtrudel's avatar
mtrudel
New Member
9 years ago

As of oct 9 2016, you CANNOT refresh even manually with Power BI Free

I spent a full day (oh yeah) installing/uninstalling Personal/Enterprise gateway.

In all attempts, REFRESH NOW or SCHEDULE REFRESH gets me to a page saying:

 

 This dataset contains on-premises data sources. To schedule data refresh, try Power BI Pro for 60,00 days, or contact your Office 365 tenant administrator to purchase Power BI Pro.

 

Gosh a just RE-READ for the Nth time the product comparison page. Did not see it before but it is clear.

Only the pro can Access on-premise data source (schedule AND manuel)

Data Refresh

Consume content that is scheduled to refreshDailyHourly
Consume streaming data in your dashboards and reports10K rows/hour1M rows/hour
Consume live data sources with full interactivity •
Access on-premises data using the Data Connectivity Gateways (Personal and Data Management) •
ibarrau's avatar
ibarrau
Super User
9 years ago

I have the same issue. I am working with a new customer and when i had all ready and try to configure the gateway to "refresh now", the message you text is shown. This is crazy, please don't remove refresh now from free content, i can lose so much customers because of this.

I read this change and now can't with on premise gateway, but at least let us use the personal gateway as free.

  • asjones's avatar
    asjones
    Helper V
    9 years ago

    Anyone found a solution to this?  We may later buy PowerBI but we are in the early stages with simple stuff.

     

    There does not seem to be an easy way to do a manual refresh of data anymore.

     

    thanks

     

    Alan

     

    • kcwilsonii's avatar
      kcwilsonii
      Helper I
      9 years ago

      Review the diffence between using a gateway and not using one.

       

      The desktop version is free, it seems you get into licensing issues when you use a gateway.

      I am have trouble at work getting the IT Licensing expert to understand this too.

       

      Microsoft appears to have confused the issue with a the gateway option, which seems to me to be

      a cloud service they are trying to implement. But if you don't need a cloud service and you and on premise

      database server just download the free version of PowerBi desktop and connect direcly to your database resource.

       

      I can do this SQL Analysis Services using a the connect live option without any gateway needed