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.
Hello Everyone
Would really appreciate help on this . I am new to Power BI and a bit confused
I am loading a very large excel flat files into Power BI and using Power Query to break the data into a fact and dimensions tables
And the usual cleaning and connecting of data
I see that Incremental Refresh (Power BI Premium ) is based on a time stamp on a loading table so my questions are
Does Incremental refresh work on more than one table at a time if you have several of the same tables coming from differnt sources but only one or two have changes) ?
Hows about if the structure of a tabel changess ie someone adds a column ?
How does it handle if there is alot of modeling in Power Query ?
Is there a better alternative to handle large flat files that need to be modelled and uploaded than using incremental refresh ?
I also have a query about getting data from MS SQL into Power BI with a Data Gateway
I read and not sure if true that the Data Gateway does not work with an SQL Stored Procedure ..is this still true ?
Can one load Temp tables directly into Power BI or would it be better to use VIEWS ?
I want to keep the SQL data strutures but has anyone any idea which is the most efficient way to get the SQL data tables through a Data Gateway into Power BI if a Premium or PRO user
Thank you
Solved! Go to Solution.
@UserMonmore I believe it is still a requirement that incremental refresh sources support Query Folding, which rules out Excel files and other flat files like CSV's, etc. Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
@UserMonmore I believe it is still a requirement that incremental refresh sources support Query Folding, which rules out Excel files and other flat files like CSV's, etc. Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
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 |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |