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.
I want my table datset to use directquery and autorefresh everyminute or so from the database using "page autorefresh" .
This imported sql server table however is refusing to cooperate.
Below is the initial source step - how to fix?
Once imported i do a few edit query operations on it to clean it up.
Solved! Go to Solution.
Hi @StephenF ,
The term modeling in this context means the act of refining and enriching the raw data, as part of authoring a report using it. Examples include:
To learn more details ,you could read the following article:
About using DirectQuery in Power BI:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Wish it is helpful for you!
Best Regards
Lucien
Hi @StephenF ,
Hi @StephenF ,
The term modeling in this context means the act of refining and enriching the raw data, as part of authoring a report using it. Examples include:
To learn more details ,you could read the following article:
About using DirectQuery in Power BI:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Wish it is helpful for you!
Best Regards
Lucien
Hi @StephenF
Direct Query mode comes with some limitations
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Is there a list of these exact limitations? - need to know what i will have to move to the sql server and do there.
Unfortunately I don't.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |