Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Organize my data in Power Query or Power BI Service? Power Bi Pro's, please help me :)

Hey Power BI Community! I have a question regarding organizing my data, and I really don't find any source where it is explained well: I have different data sources that all come from sharepo...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

 

You can use dataflows Dataflows to create one data source "Fruit salad"
https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

 

 Later you can create a desktop file / report / dashboard with RLS, so the users are restricted to what they can see.
https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Mariusz,

     

    this makes sense, I tried to organize my data with data flows, but it seems that I need a Premium Licence (I need linked Entities) which is far too expensive, this brings me back to Datasets, right?

    So the same question arises again, which version is the best?

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi Anonymous 

       

      You can reference the tables as long as you switch off Enable Load on the tables that you need to reference. 

      Why do you need to link entities? 

       

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Mariuszthanks for your reply again.


        When I load the dataflow I created in Power BI Desktop, it says "Empty Table" in the Power Query Editor.

        I need to link entities because I am merging two tables from two different sources.

         

        Dataflows doesnt seem to work, could you answer my first question again without dataflows ? 🙂