Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |