Forum Discussion

Boyan's avatar
Boyan
Icon for Helper I rankHelper I
5 years ago
Solved

Can't mix data sets - static and data gateway? All static or all gateway works but not mixed?

HI everyone,   I have a report with all static datasets. By static I mean bunch of spreadsheets. They get embedded into PBI upon publishing and all is well. Then I added a SQL source. All works on ...
Need Help
  • Boyan's avatar
    Boyan
    5 years ago

    Thank you lbendlin and lbendlin - ok so I think I got to the bottom of it. Just as lbendlin accurately corrected me - data sets fail when attempted to refresh. It's a one time deal as part of the push to the workspace. Thanks guys

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI Boyan,

Your data sources are referenced from local device files, it needs to be configured on your gateway even if they do not change anymore. Or your report not refresh due to not all data sources configured correctly.

Configure scheduled refresh 

Data refresh in Power BI 

For this scenario, I agree with 'bendlin' 's suggestion, you can consider to move them to a network driver and get data from them. After these steps, these data source not require a gateway to refresh.

Use OneDrive for Business links in Power BI Desktop 

Regards,

Xiaoxin Sheng

Boyan's avatar
Boyan
Icon for Helper I rankHelper I
5 years ago

Hi everyone,

I see few people have responded to me and I really appreciate your input.

 

I'm afraid I've failed to communicate effectively and that's on me :). My core issue here is inconsistency between how one would approach a Power BI report design. If the report is created in Desktop and then few spreadsheets are loaded as data sources (say from my local c:\temp) then upon publishing the report to PBI service NO gateway is required and of course - the service can't see my C:\ drive yet it works - that's because the spreadsheets are embedded on the fly as data set in PBI cloud service.

 

Learning from that experience I figured ok I would keep the spreadsheets as data sources but add just one SQL source. Well as soon as I do that then ALL data sources, including those that worked before now must be sourced via a gateway? (and yes of course I can get all of them gateway-sourced via SharePoint, OneDrive or what not, this isn't the issue)

 

Why is that? 

 

Thank you

~B

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Boyan,

    In fact, this not means each type of data source requires a gateway.

    Power BI data sources 
    E.g. you are mixed multiple data source and one of them require to use the gateway to handle refresh. 

    For this scenario, you need to use configure the gateway of this data set and enable the option to use the gateway handle cloudy Datasource if this type of data source existed in your dataset.

    Merge or append on-premises and cloud data sources 

    BTW, if your sheet no have too many records, you can also consider using the 'enter data' feature to import data to power bi. Power bi will recognize them as static data and not required to handle with a gateway.
    Regards,

    Xiaoxin Sheng