Forum Discussion

paulwozniak's avatar
paulwozniak
Helper I
9 years ago
Solved

OneDrive refresh via Data Gateway

I have a Power BI desktop report that I've published to the Power BI service. It uses a few data sources including:   * Microsoft SQL Server * Google Analytics * Web -> A link to a CSV file in On...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi paulwozniak，

     Using On-premises gateway, it is not possible to schedule refresh for your dataset when you mix on-premises SQL data source and CSV on Onedrive. This is a known issue that has been submitted in the following link and the feature that using on-premises gateway to work with online data sources is under review, please vote it.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources.

    However, using personal gateway, you are able to schedule refresh for the dataset when you mix data sources(on-premises SQL and CSV on Onedrive).

    In addition, you can install the personal and On-premises gateway gateway on the same computer.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi paulwozniak,

Do you use on-premises gateway or personal gateway to refresh your dataset?  On-premises gateway doesn't allow you to combine online data sources and on-premises data sources.

When you combine the following three data sources in a dataset, you can use personal gateway instead. 

* Microsoft SQL Server

* Google Analytics

* Web -> A link to a CSV file in OneDrive for Business

And for the web source, you should be able to use aAuth2 as shown in the following screenshot.



Thanks,
Lydia Zhang

paulwozniak's avatar
paulwozniak
Helper I
9 years ago

That's a great insight! Do you know if I can have both the personal and on-premise data gateways installed on one machine and profile?