cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Mixed source in dataset

I can't see a post that matches eactly what I am seeing, but if someone can direct me to one I'd be grateful.

 

I've got multiple reports based on the same PBIX template, that uses dataflows for most data but 3 sources are not available from the same on prem data source that the flows use, so I added these as Sharepoint sourced files. The dataflows refresh fine and it seems to refresh OK manually in desktop, but the dataset(s) for the report can't be configured to automatically refresh. The attached shows what the gateway refresh shows.

Gateway refresh.JPG 

 

did see this post and I'm wondering if it indicates that I can't mix 2 online sources (Dataflow and SharePoint), but it seems to indicate the only issue is with mixed on and offline sources?

https://community.powerbi.com/t5/Power-Query/Data-Gateway-does-not-refresh-datasets-on-mixed-datasou...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Mixed source in dataset

Hi there

Can you make sure that you have enabled the setting to allow for both On-Premise and cloud data sources as detailed in the Microsoft Docs below?

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Mixed source in dataset

Hi there

Can you make sure that you have enabled the setting to allow for both On-Premise and cloud data sources as detailed in the Microsoft Docs below?

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Mixed source in dataset

That was already checked. However, I now find that if I toggled the gateway on and then re-applied the scheduled refresh settings it seems to have worked even though it still says the gateway isn't correctly configured. It appears that the error is more of a warning than a stop error. It would be helpful if the errors indicated whether they were advisory or potentially process breaking. 😕

Highlighted
Super User IV
Super User IV

Re: Mixed source in dataset

Yeah I agree, you want to know if it is working or of it has failed and needs some action!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Helper IV
Helper IV

Re: Mixed source in dataset

It's not a solution as it was already checked. Did you mark your own post as a solution, as I didn't?

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors