The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Power BI experts,
I am new to Power BI but have been using Power Query for years. Recently, my company wanted to move our Rshiny applications to Power BI. I am the only person who design, develop and maintain those Rshiny applications within the team at present so I understand them very well but I have minimal knowledge of Power BI. Therefore, I hope to get some guidance from this community how I should do it in Power BI or whether it is doable in Power BI.
Can you please give some guidance and advice here?
Solved! Go to Solution.
There's a term for this. "Fighting the API". You are asking if you can make Power BI behave like Rshiny. You can not. Instead, ask yourself what your business reporting goals are, and then see if you can implement these with Power BI, based on Power BI's native capabilities.
Read about Direct Query, Import Mode, and Incremental Refresh. Read about RLS (Row Level Security). Read about sharing content via apps in a Premium/Fabric capacity. Read about Query folding. That can alleviate some of your concerns. Pushing transforms upstream is an acceptable approach in Power BI.
If your company permits it, create a Fabric Trial Capacity and do a proof of concept.
Hi @ngocanhnguyen23 ,
I hope this information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.
Thank you!!
Hi @ngocanhnguyen23 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you!!
Hi @ngocanhnguyen23 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you @lbendlin for the prompt response.
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
There's a term for this. "Fighting the API". You are asking if you can make Power BI behave like Rshiny. You can not. Instead, ask yourself what your business reporting goals are, and then see if you can implement these with Power BI, based on Power BI's native capabilities.
Read about Direct Query, Import Mode, and Incremental Refresh. Read about RLS (Row Level Security). Read about sharing content via apps in a Premium/Fabric capacity. Read about Query folding. That can alleviate some of your concerns. Pushing transforms upstream is an acceptable approach in Power BI.
If your company permits it, create a Fabric Trial Capacity and do a proof of concept.
User | Count |
---|---|
5 | |
5 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
4 | |
4 | |
4 |