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 All,
I have a Power BI Desktop model uploaded to PowerBI.com.
The model has data source from on premises xls files and on premises SQL DB.
I configured a personal gate way, and signed up for the pro account.
when I am trying to scheduale a refresh of the dataset I get an error :
"You can't schedule refresh for this dataset because one or more sources currently don't support refresh"
Thanks
Solved! Go to Solution.
It seems that using my own parameter configuration (as described above) does not work for schedualing refresh.
I replaced the connection parameters with the new build in functionality in query editor and now it works fine.
This happened to me too. Turned out that the organisational firewall didn't like the personal gateway. have a chat with IT about getting it opened up.
@BIXL
This looks to be an error with your connection string/ one or the your Mashup text. Could you explain what you're trying to do? if you'd like to share it offline, send me an email to dimazaid@microsoft.com and we can take a look.
Hi @dimazaid,
My connections in pbix file are arranged as followed :
1. have a local table in the model CONNEX_PARAMS : Table.FromRows(Json.Document)... that has the following :
Server | DB_Name | Files_Location |
<My Server> | <SQL DB NAME> | f:\powerbi\ |
2. all other tables are using this parameter table instade of hard coded.
for example for files :
Files_Location=CONNEX_PARAMS{0}[Files_Location],
File_Name="FILE1.xls",
File_Full_Path= Files_Location & File_Name,
Source = Excel.Workbook(File.Contents(File_Full_Path), null, true)
for example for SQL tables :
Server=CONNEX_PARAMS{0}[Server],
DB_Name=CONNEX_PARAMS{0}[DB_Name],
Source = Sql.Database(Server, DB_Name)
thanks
It seems that using my own parameter configuration (as described above) does not work for schedualing refresh.
I replaced the connection parameters with the new build in functionality in query editor and now it works fine.
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.