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 there,
My report mainly contains data derived from SQL, with one set of data coming from Excel. I've disabled the load and refresh options for the Excel table:
However, when I try to set up the scheduled refresh on the report server, it doesn't allow me to:
How can I overcome this issue please?
Thanks.
Solved! Go to Solution.
Unfortunately the scheduler cannot see into your data model to see if the data sources are used or not.
Since it looks like you are already using a network drive for this one fix would be to configure this connection to use a UNC path instead of the drive mapping (this is because the M: drive is specific to your user and does not exist on the server). If you open Windows Explorer you should see some other text infront of the M: drive. It will be in the form of "<share_name> ( \\<server_name>) (m:)"
so instread of referencing the file as: m:\administration\f&c\...
you should be able to use: \\<server_name>\<share_name>\administration\f&c\....
If you change this in Power BI Desktop then re-upload the file to the Report Server you should then be able to store credentials against all you data sources and then you can configure a scheduled refresh. You should even be able to enable the Excel file for refresh if you wanted to.
Unfortunately the scheduler cannot see into your data model to see if the data sources are used or not.
Since it looks like you are already using a network drive for this one fix would be to configure this connection to use a UNC path instead of the drive mapping (this is because the M: drive is specific to your user and does not exist on the server). If you open Windows Explorer you should see some other text infront of the M: drive. It will be in the form of "<share_name> ( \\<server_name>) (m:)"
so instread of referencing the file as: m:\administration\f&c\...
you should be able to use: \\<server_name>\<share_name>\administration\f&c\....
If you change this in Power BI Desktop then re-upload the file to the Report Server you should then be able to store credentials against all you data sources and then you can configure a scheduled refresh. You should even be able to enable the Excel file for refresh if you wanted to.
Thank you!
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.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |