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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You will want to explain that a bit more. When you say static do you mean you use the Power Query "Enter Data"  dialog?  Or are these files on your local PC (please say no!)?

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

Hi, sorry, by static I mean an Excel sheet on my local PC. If all of them are XLS on my local PC then they get embeded to the  report when publishing it to PBI. However as soon as I have SQL queries then it no longer wants to embed the Excel sheets and instead expects the gateway to find them - which of course can not be done