The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have prepared the dataset in Powerbi. The data comes from SharePoint and holebase(SQL database). I have merged them and then published.
However, can not schedule a refresh.
Could you please assist with this regard?
Solved! Go to Solution.
HI @yusif1999 ,
You will need a Gateway to refresh data coming from SQL Server.
Check the link that I shared earlier on Data refreshes in Power BI.
Could it be the problem that, the source is marked as "Table"? The reason why it is a table is that the query is the end result of merged tables from different source
Thanks for youre reply.
The error is:
"You can't schedule refresh for this dataset because the following data sources currently don't support refresh:"
HI @yusif1999 ,
What is the source of your data?
There are certain data-sources in Power BI that don't support Schedule refreshes.
Check the following link with the list of data-sources that support Schedule Refresh in Power BI Service:
https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
Hello ,
Thanks for your comment.
the sources are "SQL server" and "SharePoint", so it should be okay. For being sure, I have tested to publish them separately and try to refresh the data.
With SharePoint one, it went okay.
However, with SQL server, it gives the following error:
HI @yusif1999 ,
You will need a Gateway to refresh data coming from SQL Server.
Check the link that I shared earlier on Data refreshes in Power BI.
Thanks a lot. It worked!
HI @yusif1999 ,
When you say you cannot schedule refresh for the dataset; what do you mean by this?
Are you getting any error while scheduling refresh? Can you kindly add more details here?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
It is another attached screen of the error that I get.
Thanks in advance for the assistance!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
101 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
100 | |
76 |