They can already use the Excel file to create pivot tables to perform their own analyses. So now half of the task is done! You can already send this file to the end-users. You can also rename Table1 and Table2 in the Queries and Sheet names to make them more meaningful.Īfter all these steps, click “Close & Load” in the top left corner to load the data from PBI dataflow to Excel. You can add as many tables in the PBI dataflow as possible just by copying Table1 and adjusting the value for the varTableName variable as in the previous step. If you have more tables, simply repeat the steps. That’s it! Let’s begin with how to make it done. Refer to this Microsoft document for more guidance. You have already created one dataflow, and the data is already stored in the ADLS Gen2 account.You are the owner of that ADLS Gen2 account, so you can modify the ACLs for end-users.Details about the integration can be found here Your PBI dataflows are stored in an ADLS Gen2 account of your organization.Most of the configurations needed are already arranged in the M scripts hosted on my GitHub repo. The good news is that you can overcome this limitation. This post also proposes an alternative to the existing PBI dataflows connector to Power BI Desktop to push the users’ access control to the table level, instead of workspace level like the current connector.Īs mentioned, unlike Power BI, Excel doesn’t have the PBI dataflows connector yet. At the same time, while Excel is very popular among business users, there is still, at the time of writing this post, no out-of-the-box connector to import PBI dataflows to Excel. Power BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream.
0 Comments
Leave a Reply. |