Forum Discussion

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago

Large Volume of data broken up in chunks with multiple API Calls

Good day,    I have a large dataset (1m records), we are trying to provide the data to a client via an API that has a param for orgID and areaID The API only returns the dataset for the combinatio...
Need Help
icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago

Is lazy loading "like app" and paginated load "pages" possible?

What does direct query do, something i should explore?

Would exploring looping work?

Mrquestionmark's avatar
Mrquestionmark
Icon for Helper I rankHelper I
2 years ago

I might overthink your case. it sounds you just need users access your large dataset(semantic model?) based on orgID and areaID when they run report/browse semantic model. If so, using Row Level Security should be the answer.

 

 

 

  • icassiem's avatar
    icassiem
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Hi Mrquestionmark , There's no semantic layer, the users are external clients that needs to use the API to build their reports. The API was designed to only return data from operational/prod DB for a ordid + areaid but we need to build reports for an org with all its areas. I was hoping i could custom connect and loop the api call based on the list of areas, any ideas plz?

    • Mrquestionmark's avatar
      Mrquestionmark
      Icon for Helper I rankHelper I
      2 years ago

      I do not know how api works in this case. Can you use dataflows to share your data? it is a neat solution 

       

      you can ask Copilot for the details

       

      dataflows in Power BI Service can be shared with external users, but there are specific steps and conditions that need to be met for this to be possible. Here’s a high-level overview of the process:

      Azure Active Directory B2B: External sharing in Power BI is built upon Azure Active Directory (Azure AD) B2B (Business-to-Business). You need to invite external users as guest users in your Azure AD tenant1.

      App Workspace: The external users must be added to an App Workspace in Power BI Service. You need to grant them access to the workspace where the dataflow is published.

      Permissions: Ensure that the external users have the necessary permissions to view or edit the dataflow. Typically, they would need to be assigned the role of a Member or Contributor in the workspace2.

      Power BI Licensing: Both the content sharer and the external user need to have appropriate Power BI licensing. This usually means both parties should have Power BI Pro licenses, or the content should be in a workspace that is in a Power BI Premium capacity3.

      For a detailed guide and the latest updates on sharing Power BI content with external users, including dataflows, you should refer to the official Microsoft documentation1.