Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I got my report done with 2 sources
1 SQL database
1 local excel file
my need is just to refresh the sql database, but I can't since the file local excel, powerbi automatic refresh doesn't find the file....
can I exclude the excel from refresh and refresh just the SQL database data source?
Solved! Go to Solution.
@snifer ,
I'm afraid schedule refresh is implemented on the whole dataset, not the separated data source. If one of the datasource hasn't been configured correctly(e.g.: gateway), the refresh will fail. You may create two different report based on excel and sql server and refresh them seperately.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@snifer ,
I'm afraid schedule refresh is implemented on the whole dataset, not the separated data source. If one of the datasource hasn't been configured correctly(e.g.: gateway), the refresh will fail. You may create two different report based on excel and sql server and refresh them seperately.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
so there is no way to say to powerBI in query mode just to import this excel file and keep like that without refreshing?
@snifer ,
Yes, so I would suggest you to create two datasets and configure schedule refresh to the database.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
80 | |
65 | |
62 | |
60 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |