Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RudolphVan
Frequent Visitor

Loading Real Time Data

Hello Everyone

I'm encountering an issue with loading columns with real-time data before going to power query. Specifically, I'm finding it challenging to ensure that the data loads correctly with the designated delimiter.

Typically, I attempt to rectify this by adjusting the delimiter to the appropriate type (in this case, a comma), refreshing the preview to verify the changes. However, upon completing the preview evaluation, the delimiter often reverts to a custom setting without displaying any data. It's only after multiple refresh attempts, sometimes just a few and other times quite a alot, that the preview finally populates with the necessary data to proceed to the next stage of data transformation.

Please see the below screenshots as reference:

Preview.png

After evaluating.png

I am looking for your support.

Thanks in advance.

 

1 ACCEPTED SOLUTION
johnbasha33
Super User
Super User

@RudolphVan 

It seems like you're encountering an issue with the data loading and delimiter settings in Power Query. Here are a few steps you can try to troubleshoot and resolve the issue:

1. **Check Data Format**: Ensure that the data in your source file is consistent and correctly formatted. Sometimes, inconsistencies in data formatting can cause issues with delimiter detection.

2. **Refresh Preview**: After adjusting the delimiter settings, try refreshing the preview multiple times to see if the data loads correctly. Sometimes, it may take a few refresh attempts for Power Query to recognize the delimiter correctly.

3. **Force Delimiter**: Instead of relying on automatic delimiter detection, try manually specifying the delimiter in the Power Query settings. You can do this by selecting "Delimiter" from the Home tab and choosing "Comma" or your desired delimiter.

4. **Review Source File**: Check if there are any special characters or anomalies in the source file that might be affecting the delimiter detection. Sometimes, hidden characters or unusual formatting can cause issues.

5. **Data Source Configuration**: Ensure that the data source connection settings are configured correctly. If you're connecting to a file, verify the file path, encoding, and other connection details.

6. **Update Power BI Desktop**: Ensure that you're using the latest version of Power BI Desktop. Sometimes, issues with delimiter detection may be resolved in newer versions of the software.

7. **Clear Cache**: Try clearing the cache in Power BI Desktop. Sometimes, cached data or settings may interfere with the delimiter detection process.

8. **File Encoding**: Check if the file encoding is compatible with the delimiter settings. If the file is encoded in UTF-8 or another encoding, ensure that Power Query is configured to handle it correctly.

By following these steps, you should be able to troubleshoot and resolve the issue with delimiter detection in Power Query. If the problem persists, you may need to further investigate the source file or seek assistance from Power BI support forums.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

View solution in original post

2 REPLIES 2
RudolphVan
Frequent Visitor

Thank you very much

 

johnbasha33
Super User
Super User

@RudolphVan 

It seems like you're encountering an issue with the data loading and delimiter settings in Power Query. Here are a few steps you can try to troubleshoot and resolve the issue:

1. **Check Data Format**: Ensure that the data in your source file is consistent and correctly formatted. Sometimes, inconsistencies in data formatting can cause issues with delimiter detection.

2. **Refresh Preview**: After adjusting the delimiter settings, try refreshing the preview multiple times to see if the data loads correctly. Sometimes, it may take a few refresh attempts for Power Query to recognize the delimiter correctly.

3. **Force Delimiter**: Instead of relying on automatic delimiter detection, try manually specifying the delimiter in the Power Query settings. You can do this by selecting "Delimiter" from the Home tab and choosing "Comma" or your desired delimiter.

4. **Review Source File**: Check if there are any special characters or anomalies in the source file that might be affecting the delimiter detection. Sometimes, hidden characters or unusual formatting can cause issues.

5. **Data Source Configuration**: Ensure that the data source connection settings are configured correctly. If you're connecting to a file, verify the file path, encoding, and other connection details.

6. **Update Power BI Desktop**: Ensure that you're using the latest version of Power BI Desktop. Sometimes, issues with delimiter detection may be resolved in newer versions of the software.

7. **Clear Cache**: Try clearing the cache in Power BI Desktop. Sometimes, cached data or settings may interfere with the delimiter detection process.

8. **File Encoding**: Check if the file encoding is compatible with the delimiter settings. If the file is encoded in UTF-8 or another encoding, ensure that Power Query is configured to handle it correctly.

By following these steps, you should be able to troubleshoot and resolve the issue with delimiter detection in Power Query. If the problem persists, you may need to further investigate the source file or seek assistance from Power BI support forums.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.