The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
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 |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |