ISOLATE your Datasets from your Reports for EASIER COLLABORATION // Power BI Guide 2021

Рет қаралды 12,939

Күн бұрын

In this video were going to cover how you can separate your datasets from your reports easily in order to make report development collaboration easier.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of KZfaq.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Пікірлер: 21

@tacijjola Жыл бұрын

Wow! Amazing! Thank you so much, this is so useful.

@Psalm23-4ZA Жыл бұрын

Thank you for help much appreciated

@noeljuan5353 2 жыл бұрын

TYVM.

@SolutionsAbroad 2 жыл бұрын

You're very welcome!

@Akshita9614 2 жыл бұрын

Happy Holi Farnan. Your videos are so helpful. You taught me Power BI.. Wish you can teach me python too.

@SolutionsAbroad 2 жыл бұрын

Thanks for your kind words! Unfortunately I'm also still a Python novice, perhaps we'll start covering these soon!

@mttwss 2 жыл бұрын

Thanks!

@SolutionsAbroad 2 жыл бұрын

No problem, thanks for your generosity, appreciate it!

@sathiyapriya6119 2 жыл бұрын

Thanks for the informative session. Could you also let me know if i use that dataset in excel, it become slow. Can u pls suggest me the ways to overcome this performance issue while dataset is connected to excel? Thanks in advance

@pauf.9111 Жыл бұрын

Thanks for the informative session. One question, If you republish the Dataset (PBI Desktop with model and no pages), a blank report will be created again with the name of the dataset ?

@dtaraboletti 10 ай бұрын

Thanks for this very helpful video. I have a question... When i follow the steps provided, for some reason, the visual file is creating its own dataset file when published instead of a direct link to the dataset file. Can you help me to understand what I did wrong? I wish to have the automated refresh of the dataset immediately apply to the visual report.

@goodideatia Ай бұрын

I am having the same issue. I created a report connected to my dataset but when publishing the report, it also publishes a new semantic model (dataset).

@FJ-ow5lm 11 ай бұрын

Thank you for the video. I would like to get your input. I have a large dataset that consist of all clients data. I know that I can create a report and use filter to filter just for a specific client and publish it then give viewer permission so that the client will view only their own data. If the client would like to have access to their own data, how do you share the dataset through PBI web? I noticed that even if I filter out the specific client in the report/visualization, the dataset will still contain all clients data. Thanks again.

@antoniogarrido3058 2 жыл бұрын

Interesting topic! I wonder if it could be possible to connect a report to several dataset...

@SolutionsAbroad 2 жыл бұрын

Hi, of course you can! Just make sure you're on the most recent version, and the settings under Preview called "...Live AS Connection" is enabled Hope that helps!

@sivachowdary388 Жыл бұрын

Please do video for single dataset multiple reports

@gerardcanals1526 2 жыл бұрын

Thanks! I want to share with you one problem with splitting report and dataset. If we publish the dataset in one workspace and the report in another workspace, the users need to be at least contributor at both workspaces to download reports created by using the dataset. I reported this issue and they actualized the list of limitations and proposed an idea to solve it. This is a limitation and it is quite confusing since, if you give build access to users to the dataset, then, they can create, publish, view and edit reports with this dataset, but they can't download it. Please, would you vote for the idea to solve this problem?

@android01978 Жыл бұрын

I've found the easiest way to separate the report from the dataset is to open the report in power bi web and download a copy without the dataset (as linked online) then rename the file before opening in power BI and publishing it.

@wanmuhammadfazliwankauzi5091 2 жыл бұрын

I have a question . when we use dataset to create visualize and save it as analytics and publish . how can we set the security level ? as the security level only can set on the dataset not the analytics.

@SolutionsAbroad 2 жыл бұрын

Perhaps you're looking for Row-level security: kzfaq.info/get/bejne/mZulrJt33K6XaZ8.html