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

"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"

 

That is incorrect. Spreadsheets are not embedded on the fly.   Your setup only works if you keep updating the PBIX file on the dektop and then push the update to the workspace. The moment you try to schedule  refresh on the workspace it will fail.

Boyan's avatar
Boyan
Icon for Helper I rankHelper I
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,

    I'm glad to hear this helps.🙂

    If you faced some issues again, you can feel free to post your questions here.
    Regards,

    Xiaoxin Sheng