Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a pbix uploaded to Service. In the pbix, I have an online source from a csv through a web-connection, and it refreshes as it should.
In the datamodel, I have added an Excel table from my OneDrive. Data here are fixed, and no refresh is needed.
I have checked the "include in report refresh" off in Power Query for the Excel table.
The problem is: In Service, I can't shedule a refresh on the dataset, as it says that a Gateway is needed. I can't use a Gateway, as my computer will be off regularily.
Furthermore, I don't need that Gateway, as I don't need to refresh the Excel data. I only need to refresh the data from the web-connection, which does not need a Gateway. When excluding the Excel data, refresh is running fine (without Gateway).
Which steps are necessary to take in order to get rid of that message and to make refresh only to be about the web-connection data?
Solved! Go to Solution.
Hi @MarianneElver,
Based on my research, I am afraid you could not achieve this feature, if you want to set the refresh, it will refresh the whole data in your data source. You could not just refresh the web data.
Regards,
Daniel He
Hi @MarianneElver,
From your description, if your data source includes the data from web, you need to configure a gateway for it.
Reference:https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#list-of-available-data-source-types
Regards,
Daniel He
Hi @MarianneElver,
Based on my test, if your data source used the web.Page function, you need to configure a gateway for the datasource.
Reference:https://docs.microsoft.com/en-us/power-bi/refresh-data#power-bi-desktop-file
You could check it in the Advanced languae in query editor:
And it could work on my side:
I suggest you test it again.
Regards,
Daniel He
Hi @MarianneElver,
Based on my research, I am afraid you could not achieve this feature, if you want to set the refresh, it will refresh the whole data in your data source. You could not just refresh the web data.
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.